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
- Select you Data Set. Now go to Insert tab and select Chart-> Column. [adsenseyu2]
Now you Chart is ready. - Select the series in Chart for which you want a different Chart type.
Now Right Click and select change series chart type.
Select line 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.