add a secondary y axis to a graph in excel for mac

Use the chart customization buttons that appear in the top right corner of your Excel graph when you click on it.Įven more customization options can be found on the Format Chart pane that appears on the right of your worksheet as soon as you click More options… in the chart's context menu or on the Chart Tools tabs on the ribbon.

Right-click the chart element you would like to customize, and choose the corresponding item from the context menu.

Select the chart and go to the Chart Tools tabs ( Design and Format) on the Excel ribbon.

If you've had a chance to read our previous tutorial on how to create a graph in Excel, you already know that you can access the main chart features in three ways:

And further on in this tutorial, you will learn some quick ways to add and modify all essential elements of Excel charts. Microsoft has really made a big effort to simplify the process and place the customization options within easy reach. In modern versions of Excel, customizing charts is easy and fun. After you have created a chart in Excel, what's the first thing you usually want to do with it? Make the graph look exactly the way you've pictured it in your mind!

Add a secondary y axis to a graph in excel for mac