Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Secondary axis
I have a stacked bar chart with cases sold on the right axis, and the week
ending on the y axis. I need to create an additional x axis on the right side with the avg price numbers. How do I do this? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Secondary axis
Let's get the names right first. The vertical axis (up and down) is the Y
axis, while the horizontal axis (left to right) is the X axis. I think you want a secondary Y axis. Double click the second data series on the chart to open the Format Data Series dialog, open the Axis tab and select Secondary y-axis. best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "PB" wrote in message ... I have a stacked bar chart with cases sold on the right axis, and the week ending on the y axis. I need to create an additional x axis on the right side with the avg price numbers. How do I do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to make Primary axis and Secondary X-axis have the same scale | Excel Discussion (Misc queries) | |||
Secondary Axis | Charts and Charting in Excel | |||
Secondary Axis Match Primary Axis Gridlines | Charts and Charting in Excel | |||
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel | |||
How do I set permanent secondary axis in PivotTable chart? | Charts and Charting in Excel |