ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Adding a secondary axis to an exisitng chart (https://www.excelbanter.com/charts-charting-excel/149905-adding-secondary-axis-exisitng-chart.html)

Randy

Adding a secondary axis to an exisitng chart
 
When working through the Excel Help explanation, I can't find the "Series
Options" Where is it?

Bernard Liengme

Adding a secondary axis to an exisitng chart
 
Right click on one of the data series in the chart and from the shortcut
menu use Format Series;
Open the Axis tab and click on the Secondary Axis option
If the chart is column you will need some extra steps; see
http://peltiertech.com/Excel/Charts/...OnTwoAxes.html
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Randy" wrote in message
...
When working through the Excel Help explanation, I can't find the "Series
Options" Where is it?





All times are GMT +1. The time now is 06:03 AM.

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