In this tutorial, I’ll show you how to combine two chart types to better present two different sets of data.
1.Go to File>Open and open the workbook containing the data that you want to combine in one chart.
2.Next go to Insert>Chart Type. The Chart Wizard pop up window will appear, so click on the Custom Types tab. Now go down to the chart type called “Lines on 2 Axes,” select it and click Next.
3.Next, select the range with the two different types of data and click Next.
4.Add titles and any other pertinent information, and click Next.
5.Finally click on the “place chart as new sheet” option and hit Finish.You’ll see the two sets of data nicely combined in one chart -as in the example below.
Fantastic! Sometimes it makes sense to combine two charts into one to really emphasize the relationship of the data and their impact.
Loading ...