Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

How to create combination charts and add secondary axis for it in Excel?

In Excel, we always need to create charts comparing different types of data. There are several chart types we can use, such as column, bar, line, pie, scatter chart and so on. Sometimes it's necessary to plot two or more sets of values to show multiple types of data, such as a column chart and a line graph. In this case, you can create a combination chart which is to combine two different charts to make one (see following screenshots). Today, I will talk about how to create combination charts and add a secondary axis as well in Excel.

Create combination charts in Excel

Add a secondary axis for the combination charts

doc-combine-chart1
doc-button1
doc-combine-chart2
doc-button2
doc-combine-chart3

arrow blue right bubble Create combination charts in Excel


Supposing you have the following two data sources, you can create combination charts based on the data source with these steps:

doc-combine-chart4 doc-combine-chart5

1. First, we can create a column chart for the first Area data source, please select the data range and then specify a column type chart under Insert tab, and then a column chart will be created as following screenshots shown:

doc-combine-chart6
-1
doc-combine-chart7

2. Then select the Total Price data range, press Ctrl + C to copy it and then click any column in the above column chart, press Ctrl + V to paste the data into the chart. Now we have a column chart with two data sets (Area and Total Price), both charted using the same chart type. See screenshot:

doc-combine-chart8

3. In this step, we need to change one of the data sets to a line chart. Please click red bar Total Price data column in the chart, and right click, then choose Change Series Chart Type from the context menu, see screenshot:

doc-combine-chart9

4. In the Change Chart Type dialog, select one line chart type as you need, see screenshot:

doc-combine-chart10

5. Then click OK button, and now you have a chart with two chart types as following screenshot shows:

doc-combine-chart11

Note: With repeating above steps, you can combine more than two chat types, you just need to select the additional data sets and choose a different chart for each data series.


arrow blue right bubble Add a secondary axis for the combination charts

Sometimes, in a combination chart, the values of one data set vary widely from another, so it is difficult for us to compare the data from the chart. To make the chart easier to read, Excel allows us to add a secondary axis for the chart, here’s how you add a secondary axis for the combination chart in Excel.

1. In the combination chart, click the line chart, and right click or double click, then choose Format Data Series from the text menu, see screenshot:

doc-combine-chart12

2. In the Format Data Series dialog, click Series Options option, and check Secondary Axis, see screenshot:

doc-combine-chart13

3. Then click Close button, and you have successfully added a secondary axis to your chart as following screenshot:

doc-combine-chart14


Related articles:

How to auto update a chart after entering new data in Excel?

How to add a horizontal average line to chart in Excel?


Recommended Productivity Tools

Ribbon of Excel (with Kutools for Excel installed)

300+ Advanced Features Increase Your Productivity by 71%, and Help You To Stand Out From Crowd!

Would you like to complete your daily work quickly and perfectly? Kutools For Excel brings 300+ cool and powerful advanced features (Combine workbooks, sum by color, split cell contents, convert date, and so on...) for 1500+ work scenarios, helps you solve 82% Excel problems.

  •  Deal with all complicated tasks in seconds, help to enhance your work ability, get success from the fierce competition, and never worry about being fired.
  •  Save a lot of work time, leave much time for you to love and care the family and enjoy a comfortable life now.
  •  Reduce thousands of keyboard and mouse clicks every day, relieve your tired eyes and hands, and give you a healthy body.
  •  Become an Excel expert in 3 minutes, and get admiring glance from your colleagues or friends.
  •  No longer need to remember any painful formulas and VBA codes, have a relaxing and pleasant mind, give you a thrill you've never had before.
  •  Spend only $39, but worth than $4000 training of others. Being used by 110,000 elites and 300+ well-known companies.
  •  60-day unlimited free trial. 60-day money back guarantee. Free upgrade and support for 2 years. Buy once, use forever.
  •  Change the way you work now, and give you a better life immediately!

Office Tab Brings Efficient And Handy Tabs to Office (include Excel), Just Like Chrome, Firefox, And New IE

  • Increases your productivity by 50% when viewing and editing multiple documents.
  • Reduce hundreds of mouse clicks for you every day, say goodbye to mouse hand.
  • Open and create documents in new tabs of same window, rather than in new windows.
  • Help you work faster and easily stand out from the crowd! One second to switch between dozens of open documents!
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    Elo · 10 months ago
    Is there any way to put a real scale in horizontal axis?
    Here, datas are equally distanced from each other, I would like to put a horizontal numerical axis and actually have the real distance between datas.

    Do you know a way to do it in Excel?

    I hope I was clear enough... Thank you!
  • To post as a guest, your comment is unpublished.
    Eva · 2 years ago
    Good job..really helped
  • To post as a guest, your comment is unpublished.
    Kelli · 4 years ago
    You can actually create a dual axis chart in DataHero automatically by dragging two numeric attributes onto the chart. It saves you a lot of steps in Excel.
  • To post as a guest, your comment is unpublished.
    Tracy Schmidt · 5 years ago
    creating a pareto chart