Multiple independent x axis

[Gianella Azzopardi]

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/tutorial...2-29a62fc4e26e/walking-the-windows-forms.aspx

 

[David Biddulph]

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.