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

Posted on July 2nd, 2009 in Charts and Graphs , Excel Howtos - 8 comments

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:

 Best month ever [blogging updates] How to Round and Sort Data using Excel Formulas?
 Written by Chandoo Tags: 15sectuts, charting, Charts and Graphs, combination charts, data series, Learn Excel, microsoft, quick tip, secondary axis, spreadsheets, tutorials, video, videos Home: Chandoo.org Main Page ? Doubt: Ask an Excel Question

### 8 Responses to “Create a Combination Chart, Add Secondary Axis in Excel [15 Second Tutorial]”

1. [...] Select the “daily completed” column and add it to the burn down chart. Once added, change the chart type for this series to bar chart (read how you can combine 2 different chart types in one) [...]

2. [...] set the height series to be plotted on secondary axis. Learn more about combining 2 chart types and adding secondary axis in [...]

3. [...] Excel Combination Charts – What are they? [video tutorial here] [...]

4. [...] To show the years, I have used another dummy series and plotted it on secondary axis (related: how to add secondary axis?) [...]

5. Thanks for this one!

6. [...] Choisissez la colonne « Daily Completed » et ajoutez-la au graphique. Une fois ajoutée, changez le type de graphique pour cette série à histogramme (lisez comment combiner 2 types de graphiques en un : combine 2 different chart types in one) [...]

7. Nat says:

How do i create a chart that has negative numbers on axis x and y and plot them correctly? I cannot seem to understand how to do this, please help.
Thanks.

Nat

8. MSWebReviewer says:

You can also plot 2 or more Y axes in Excel using EZplot or Multy_Y from Office Expander.com
There is a demo version to try.
Cheers.

 Best month ever [blogging updates] How to Round and Sort Data using Excel Formulas?