Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
c06
 
Posts: n/a
Default 2graph with the same Xvalue and same Size of graph

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


  #2   Report Post  
Posted to microsoft.public.excel.charting
Tushar Mehta
 
Posts: n/a
Default 2graph with the same Xvalue and same Size of graph

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 ,
says...
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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 08:04 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"