If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#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 |
Thread Tools | |
Display Modes | |
|
|