2graph with the same Xvalue and same Size of graph

[c06]

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 "inside chart" 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

 

[Tushar Mehta]

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