Dec 04, 2015
Have you ever had two different types of data that you wanted to show in one chart? In Excel 2013 it is much easier to create combo charts.
Let’s look at the four steps required to do this.
Combining different chart types and adding a secondary axis
- Select the data you would like to use for your chart.
- Go to the Insert tab and click Recommended Charts.
- Click the All Charts tab and select the Combo category.
- Check the Secondary Axis box for the Total Transactions and click OK.
At the top of the dialog you will see a couple out of the box combo charts to get you started and Clustered Column – Line is the default. This combo chart will split the series 50/50 between a clustered column and a line chart. You can then use the table below the chart to change each series to a particular chart type and move series to the secondary axis.
Given that units sold and total transactions have different scales we need to move one of them to a secondary axis so we can clearly see the values for both.
As you can see it now takes four steps to create a simple combination chart.
For more information, take a look at New Horizons' Excel Training Courses.
How do your Excel skills stack up?
Test NowNext up:
- Intro and setup for Xbox SmartGlass
- My mate Stevo said it was good and Norm just couldn’t wait his turn!
- Difference between ByVal and ByRef in VBA
- Fiddly actions with Word tables
- Windows as a Service – The new Update Model
- A Recipe for Frame Fun with InDesign CC
- Word 2013 easy customisations
- Collaborative Hiring
- SharePoint 2016 – Quick facts
- Did you make a ritual?
Previously
- Hide Parts of a Page from Certain Users in SharePoint
- Embedding Organisational Values into Performance Management
- Using the Fluent API with Entity Framework
- Custom Data Validation Rules in Excel
- Using a Calendar on your Website
- Ever typed a date into Excel and it turned into a number?
- What is ITIL?
- The best features of Excel 2013 – Part 1
- Why effective leadership is like yogurt
- AngularJS Service – The Basics