Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
It's easier not to start with one of the built-in custom types. They are
less flexible than you'd expect. Make the chart using all columns or all lines. Select a series you want to change to the other type, then use Chart menu Chart Type to change it. Select another series to change, and press the F4 function key to repeat the previous action. Repeat as necessary. Then double click a series you want on the secondary axis, and on the Axis tab, select Secondary. Select a second series to change axis, and press the F4 function key. Repeat as necessary. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ wrote in message ups.com... I have an Excel chart that is a Line-Column on Two Axis. The primary axis shows columns. I am able to add the secondary axis, a line to the chart. My question is: can I add multiple lines to the secondary axis? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Add vertical lines to a line chart (already has 2 Y axis) | Charts and Charting in Excel | |||
Secondary Axis chart | Charts and Charting in Excel | |||
tick mark labels | Charts and Charting in Excel | |||
How do I make the Y axis in an excel chart the category axis? | Charts and Charting in Excel | |||
How do I set permanent secondary axis in PivotTable chart? | Charts and Charting in Excel |