| 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? |
| 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 | |||
Linear Mode
