Create a combo or two-axis chart in Excel 2016 by Chris Menard

Posted on:  03/14/2017
Create a combo or two-axis chart in Excel 2016 by Chris Menard

When the numbers in your Excel file vary widely from data series to data series and you want to create a chart, the chart to create is a Combo chart. You would also use a combo chart when you have mixed types of data (for example, revenue and net income percentage), you can plot one or more data series on a secondary vertical (value) axis. The scale of the secondary vertical axis shows the values for the associated data series.

A secondary axis works well in a chart that shows a combination of column and line charts.

Chris Menard’s Youtube channel with over 240 technology videos covering Excel, Word, Gmail, Outlook, PowerPoint, free apps, and a lot of other technology stuff.

YouTube video on combo or two-axis chart in Excel 2016

Related videos on column charts

Create a dynamic column chart that changes colors for decreases. This is a great chart when using monthly or annual data.


Chris Menard

Chris Menard is a Senior Training Specialist at SurePoint Technologies. Chris is certified in Excel, Word, PowerPoint, and Outlook. Menard has a YouTube channel with other 600 technology videos covering Excel, Word, Zoom, Teams, Outlook, Gmail, Google Calendar, and other resources that over 7 million viewers have very appreciated. Because of Chris's certification and expertise with Microsoft, Chris is a proud member of Microsoft's Creator Team. Being a member of Microsoft's Creator Teams means many of his videos are available on Microsoft 365 YouTube channel and Microsoft support websites.