A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Multiple independent x axis



 
 
Thread Tools Display Modes
  #1  
Old November 16th, 2009, 10:03 PM posted to microsoft.public.excel.charting
Gianella Azzopardi
external usenet poster
 
Posts: 1
Default Multiple independent x axis

Hi there!

I would like to create a chart on excel which has a single y axis BUT multiple x axis. The thing is, each x axis has a different scale because they symbolize different things! ...is there a way i can do this? Perhaps i can merge different charts together? Thanks.

EggHeadCafe - Software Developer Portal of Choice
Walking the Windows Forms Control Hierarchy
http://www.eggheadcafe.com/tutorials...ows-forms.aspx
  #2  
Old November 16th, 2009, 11:00 PM posted to microsoft.public.excel.charting
David Biddulph
external usenet poster
 
Posts: 8,714
Default Multiple independent x axis

Plot your chart with more than one series.
Select the series that you want to be on the secondary axis, format data
series, axis, select secondary. It will be given a secondary Y axis.
Then Chart Options/ Axes, & select secondary X axis and unselect secondary Y
axis.
--
David Biddulph

Gianella Azzopardi wrote in message
...
Hi there!

I would like to create a chart on excel which has a single y axis BUT
multiple x axis. The thing is, each x axis has a different scale because
they symbolize different things! ...is there a way i can do this? Perhaps
i can merge different charts together? Thanks.

EggHeadCafe - Software Developer Portal of Choice
Walking the Windows Forms Control Hierarchy
http://www.eggheadcafe.com/tutorials...ows-forms.aspx



 




Thread Tools
Display Modes

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

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:29 PM.


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