Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
charting with a secondary Y axis
I am line charting budget data with the following series' Monthly Spend
representing a "spend profile"; Cumulative Monthly spend representing YTD progress; and Budget representing a target towards which the Cumulative Monthly is headed. I've added a linear trend line showing where the Cumulative spend will likely wind up by years end. My problem is I can't seem to get the secondary axis to show up as a percent of budget. Whatever the budget number is, I need it to show up at the 100% line on the secondary axis. Can anyone help? |
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 |