Creating a combination chart

A combination chart is just what it sounds like,…two different types of charts combined within a single chart.…To create combo charts, you need to…use two dimensional charts, not three dimensional charts.…And normally, what you'll do is, you'll use one type…of chart, a column for example, And to show the data.…In this case, we have our inverter sales for our K Echo Inverters…at the 1500 watt size.…But there was also a goal during this time.…

We did an internal promotion to try to increase our sales…of these 1500 watt inverters across all of the different regions.…And that goal data is here as well.…So, we want to be able to include that…in the chart, to show how we did against goal.…We'll keep this stat column chart to show how each of the regions did, and we'll…use a line chart to show the goal.…So, the first thing we need to do is we need to add this goal data to the chart.…And all we need to do to do that is grab the range finder and stretch it out.…

And here's our goal in the chart.…But the goal isn't data like the rest of this data is.…