How to Create an Excel 2016 Chart with Two Y Axes




About this tutorial:

Video duration: 1:9
In this tutorial, we’re going to show you how create an Excel 2016 Chart with Two Y Axes.

Once you have a chart and two sets of data plotted, left-click directly onto the line, columns, etc. of the set of data you want on the secondary axis. After selecting it, right-click it and choose Format Data Series.

Choose Secondary Axis instead of Primary Axis.

Optionally, to make things more visually appealing and differentiating the two axes, left-click one of them to select it. Under the Format Axis dialogue box you can change the color of it. Change the color so it matches the legend and…

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

Leave a Reply

Your email address will not be published. Required fields are marked *

How to Create an Excel 2016 Chart with Two Y Axes




About this tutorial:

Video duration: 1:9
In this tutorial, we’re going to show you how create an Excel 2016 Chart with Two Y Axes.

Once you have a chart and two sets of data plotted, left-click directly onto the line, columns, etc. of the set of data you want on the secondary axis. After selecting it, right-click it and choose Format Data Series.

Choose Secondary Axis instead of Primary Axis.

Optionally, to make things more visually appealing and differentiating the two axes, left-click one of them to select it. Under the Format Axis dialogue box you can change the color of it. Change the color so it matches the legend and…

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

Leave a Reply

Your email address will not be published. Required fields are marked *