Create a Combination Chart, Add Secondary Axis in Excel [15 Second Tutorial]

Two most commonly asked or searched queries when it comes to charting are,

• How to combine two chart types in one chart, like a line chart combined with bar chart?
• How to add a secondary axis to the chart so that one or more data series are plotted on the secondary axis?

Excel combination charts are a great way to combine two chart types in to one.

Using data series options you can plot a particular series on secondary axis.

In this quick video tutorial you can learn how to make a combination chart and add secondary axis in less than 15 seconds.

Watch it on youtube: Creating combination charts and adding secondary axis – video tutorial

More quick tips and video tutorials:

• How to remove duplicates
• Hide cell contents using formatting codes
• Hide formula errors when printing
• Editing formula references quickly using mouse
• More quick excel and charting tips

Posts & Navigation Have an Excel Question? « Best month ever [blogging updates] How to Round and Sort Data using Excel Formulas? » Go Back to Home Page Tags: 15sectuts, charting, Charts and Graphs, combination charts, data series, Learn Excel, microsoft, quick tip, secondary axis, spreadsheets, tutorials, video, videos

Comments

RSS feed for comments on this post. TrackBack URI

Leave a comment

If you have a question, please ask in the forums