Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003: Mapping rows (x-axis) vs multiple columns (y-axis) | Excel Discussion (Misc queries) | |||
Change Multiple Page Fields in two independent Pivot Tables | Excel Worksheet Functions | |||
Independent Lists... | New Users to Excel | |||
Excel : F2-F4 in multiple sheets should have independent result | Excel Discussion (Misc queries) | |||
dot plot - single x axis location with multiple y axis dots | Charts and Charting in Excel |