ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Second Y axis (https://www.excelbanter.com/charts-charting-excel/10392-second-y-axis.html)

agenda9533

Second Y axis
 
How to add Second Y axis.

Thank you

Barb Reinhardt

I believe you need to have at least 2 series on your chart for this to work.
Select one of the series and double click.

You can select the secondary axis using the AXIS menu.

"agenda9533" wrote in message
...
How to add Second Y axis.

Thank you




John Mansfield

To create the secondary axis . . .

Click on the line or column that you want to occur on the secondary axis.
Right-click on your mouse.
Choose the Selected Object option.
In the Format Data Series dialog box, go to the Axis tab.
Choose the "Plot series on secondary axis" option.

Regards,
John Mansfield
http://www.pdbook.com

"agenda9533" wrote:

How to add Second Y axis.

Thank you



All times are GMT +1. The time now is 12:26 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com