[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/tutorials...ows-forms.aspx

[David Biddulph[_2_]]

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