close

Hello

i would like to have 2 or more charts created with the same axes X values
(date).

I create 3 differents charts with the same axes value:
My problem is
- the 2 created charts has'nt the same size,
- the distance between the 2 axis values isn't the same and
- the size of quot;inside chartquot; isn't the same for the 2 graphs

With this problem i can't look just the two charts in order to compare them
at the same date (X ) because a date X on one charts isn't just below (on a
vertical line) the same date X on the second chart but maybe more on right
side.

Can you help me please ?
thanks
Assuming the dates are dates as XL understands them, chances are the
following will work.

Double-click the x-axis. In the resulting dialog box, click the Scale tab.
In there specify the desired dates for the min. and max. values. You can
use mm/dd/yyyy (or I imagine dd/mm/yyy depending on the computer's Regional
Setting) and XL will translate that into an integer value.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article gt;,
says...
gt; Hello
gt;
gt; i would like to have 2 or more charts created with the same axes X values
gt; (date).
gt;
gt; I create 3 differents charts with the same axes value:
gt; My problem is
gt; - the 2 created charts has'nt the same size,
gt; - the distance between the 2 axis values isn't the same and
gt; - the size of quot;inside chartquot; isn't the same for the 2 graphs
gt;
gt; With this problem i can't look just the two charts in order to compare them
gt; at the same date (X ) because a date X on one charts isn't just below (on a
gt; vertical line) the same date X on the second chart but maybe more on right
gt; side.
gt;
gt; Can you help me please ?
gt; thanks
gt;
gt;
gt;

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()