Prev: Showing Totals in a Data Table on a 100% Stacked Chart?
Next: Category Labels in Radar chart
From: Gianella on 16 Nov 2009 16:03
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/aspnet/cf87476e-7e4f-4d72-8702-29a62fc4e26e/walking-the-windows-forms.aspx
From: "David Biddulph" groups [at] on 16 Nov 2009 17:00
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
news:2009111616336gianellaazzopardi(a)gmail.com...
> 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/aspnet/cf87476e-7e4f-4d72-8702-29a62fc4e26e/walking-the-windows-forms.aspx


 | 
Pages: 1
Prev: Showing Totals in a Data Table on a 100% Stacked Chart?
Next: Category Labels in Radar chart