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;
- Sep 23 Tue 2008 20:46
2graph with the same Xvalue and same Size of graph
close
全站熱搜
留言列表
發表留言
留言列表

