Combining different chart types on Single Chart – MS Excel

In order to present different data types on Single excel chart, one can use different chart types. Once your data is ready, we will create chart.

Combining different chart types on Single Chart

  1. Select you Data Set. Now go to Insert tab and select Chart-> Column.
    Now you Chart is ready.Combining different chart types on Single Chart
  2. Select the series in Chart for which you want a different Chart type.
    Combining different chart types on Single Chart

    Select Change Chart type

    Now Right Click and select change series chart type. Combining different chart types on Single ChartSelect line chart.Combining different chart types on Single Chart

This if both data have a similar range but if difference between both data sets is two high, you will have to use two X axis. We will share steps for it in Part 2 of this tutorial.