Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Moving overlapping bars forwards and backwards
Hi,
I am creating a column chart with two series which are represented as two overlapping columns for each of my x-axis categories. I have two virtical axis, one for each series. My problem is that Execel automatically puts the columns associated with the secondary axis (series 2) in the foreground and the columns for the primary axis (series 1) in the background. I needs to switch this so that my primary y-axis columns (series 1) are not hidden by the secondary y-axis columns (series 2). I cant find anyway of doing this. Can anyone help! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Moving overlapping bars forwards and backwards
Switch the series so that those on the primary axis will be on the
secondary axis, and vice versa. - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ jim wrote: Hi, I am creating a column chart with two series which are represented as two overlapping columns for each of my x-axis categories. I have two virtical axis, one for each series. My problem is that Execel automatically puts the columns associated with the secondary axis (series 2) in the foreground and the columns for the primary axis (series 1) in the background. I needs to switch this so that my primary y-axis columns (series 1) are not hidden by the secondary y-axis columns (series 2). I cant find anyway of doing this. Can anyone help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving data series horizontally (offset) to prevent overlapping | Charts and Charting in Excel | |||
Customise error bars on individual bars in a bar chart 2007 | Charts and Charting in Excel | |||
Overlapping Bars Chart & Two Y Axes: how? | Charts and Charting in Excel | |||
overlapping error bars | Charts and Charting in Excel | |||
How do I get a chart to display backwards/forwards? | Charts and Charting in Excel |