How to Create an Excel 2016 Chart with Two Y Axes

7
30




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…

7 COMMENTS

LEAVE A REPLY

Please enter your comment!
Please enter your name here