| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Secondayr axis denied
I have successfully added a series to a chart, using the secondary axis.
When adding another series to the chart, Excel uses the Primary axis as default to load the series. I want to change the Primary axis to Secondary axis, but Excel does not allow that option - both options are grayed out, showing the Excel-selected Primary axis. How do I get this second series on the Secondary axis? Thanks, Phil |
|
#2
|
|||
|
|||
|
Sometimes it's not allowed. What kind of chart is it? Is the workbook shared?
- Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Phil Hageman wrote: I have successfully added a series to a chart, using the secondary axis. When adding another series to the chart, Excel uses the Primary axis as default to load the series. I want to change the Primary axis to Secondary axis, but Excel does not allow that option - both options are grayed out, showing the Excel-selected Primary axis. How do I get this second series on the Secondary axis? Thanks, Phil |
|
#3
|
|||
|
|||
|
Jon,
I closed the workbook and came back to it later. Everything worked normal. No idea of the problem. Thanks for your reply... Phil "Jon Peltier" wrote: Sometimes it's not allowed. What kind of chart is it? Is the workbook shared? - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Phil Hageman wrote: I have successfully added a series to a chart, using the secondary axis. When adding another series to the chart, Excel uses the Primary axis as default to load the series. I want to change the Primary axis to Secondary axis, but Excel does not allow that option - both options are grayed out, showing the Excel-selected Primary axis. How do I get this second series on the Secondary axis? Thanks, Phil |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel | |||
| can't change how data on 2nd axis is being displayed | Charts and Charting in Excel | |||
| How do I make the Y axis in an excel chart the category axis? | Charts and Charting in Excel | |||
| space between y axis and data points.. | Charts and Charting in Excel | |||
| Second X axis at top of chart? | Charts and Charting in Excel | |||
Linear Mode
