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 |
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