PC Review


Reply
Thread Tools Rate Thread

2graph with the same Xvalue and same Size of graph

 
 
c06
Guest
Posts: n/a
 
      8th Apr 2006
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 With Quote
 
 
 
 
Tushar Mehta
Guest
Posts: n/a
 
      10th Apr 2006
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 <4437c6b6$0$20177$(E-Mail Removed)>, (E-Mail Removed)
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 With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Setting chart Xvalue errors Robert H Microsoft Excel Programming 5 23rd Feb 2007 01:48 PM
Can I make a graph to be a specific size? (actual graph) =?Utf-8?B?SmVzc2ljYQ==?= Microsoft Excel Misc 0 14th Aug 2006 08:45 PM
Charts with Xvalue and YValue? deko Microsoft Excel Programming 2 8th Mar 2005 08:34 AM
How to get corresponding Xvalue for specific Yvalue from XYScatte. =?Utf-8?B?YXptb2RldXM=?= Microsoft Excel Charting 5 16th Jan 2005 02:45 PM
graph size =?Utf-8?B?ZmphbQ==?= Microsoft Excel Misc 1 13th Nov 2004 12:23 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:25 PM.