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

7 thoughts on “How to Create an Excel 2016 Chart with Two Y Axes

    Cookazor

    (March 14, 2018 - 9:22 pm)

    How did you make your y axis

    Meyer Speary

    (March 14, 2018 - 9:22 pm)

    Trying to make a combo chart with 2 sets of related data. When I try to do it, it stacks the columns on top of each other. I want the columns side by side. Any ideas?

    Steve Sun

    (March 14, 2018 - 9:22 pm)

    Thank you!

    Gabriele Silva

    (March 14, 2018 - 9:22 pm)

    you are better than the useless microsoft excel support!

    John Hargrove

    (March 14, 2018 - 9:22 pm)

    More thumbs up… Im a design engineer and I was struggling with this for an hour before finding this video

    andrew miller

    (March 14, 2018 - 9:22 pm)

    Thank you brother

    Jesper Møller

    (March 14, 2018 - 9:22 pm)

    Short and simple. +1

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

7 thoughts on “How to Create an Excel 2016 Chart with Two Y Axes

    Cookazor

    (March 14, 2018 - 9:22 pm)

    How did you make your y axis

    Meyer Speary

    (March 14, 2018 - 9:22 pm)

    Trying to make a combo chart with 2 sets of related data. When I try to do it, it stacks the columns on top of each other. I want the columns side by side. Any ideas?

    Steve Sun

    (March 14, 2018 - 9:22 pm)

    Thank you!

    Gabriele Silva

    (March 14, 2018 - 9:22 pm)

    you are better than the useless microsoft excel support!

    John Hargrove

    (March 14, 2018 - 9:22 pm)

    More thumbs up… Im a design engineer and I was struggling with this for an hour before finding this video

    andrew miller

    (March 14, 2018 - 9:22 pm)

    Thank you brother

    Jesper Møller

    (March 14, 2018 - 9:22 pm)

    Short and simple. +1

Leave a Reply

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