ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Multiple independent x axis (https://www.excelbanter.com/charts-charting-excel/248568-multiple-independent-x-axis.html)

Gianella Azzopardi

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

David Biddulph[_2_]

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





All times are GMT +1. The time now is 01:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com