- #1
lcr2139
- 62
- 1
Hello, I am trying to make a graph on excel 2013 with two y axes, and the internet says I should click on the "Layout" tab under the Chart Tools tab, but I do not have that tab. How do I do this?
To add a secondary axis in Excel without the layout tab, you can follow these steps:
The layout tab may be hidden in Excel if you are using an older version of the program. To show the layout tab, you can go to the "View" tab and click on "Print Layout" in the Workbook Views section.
Yes, you can also add a secondary axis in Excel by right-clicking on the data series and selecting "Change Series Chart Type". In the Change Chart Type dialog box, choose "Combo" from the left menu, and then select the chart type for your secondary axis. This will add the secondary axis to your chart.
To format the secondary axis in Excel without the layout tab, you can use the Format Axis pane. Right-click on the secondary axis and select "Format Axis". In the Format Axis pane, you can make changes to the axis labels, tick marks, and other formatting options.
Yes, you can add a secondary axis to a pivot chart in Excel without the layout tab. Simply right-click on the pivot chart and select "Format Chart Area". In the Format Chart Area pane, go to the "Series Options" section and check the box next to "Secondary Axis". The secondary axis will now be added to your pivot chart.