Create combination charts

- We're looking at a worksheet called combination…and if you look at the data in columns A, B and C,…imagine a company that has a small fleet of vehicles…and every month they track miles driven…and miles per gallon.…So without giving the data too much thought…and clicking within it,…and because it is surrounded empty cells…and worksheet boundaries, we don't even have to highlight it…we can quickly create a chart with Old F1.…And right away, we begin to recognize…this is not the best chart here…because we don't see the miles per gallon,…and because the range of numbers here is so wildly different…the magnitude of difference between these numbers…in the tens of thousands…and in these numbers in the twenties, and so on,…there are not showing up on the chart.…

But they could be.…In older versions of Excel,…trying to create what we call a combination chart…where we could actually show…both of these sets of data intelligently…was not so easily done.…I'm going to set Control Z to undo this chart.…Now, you might now be aware of how we could approach this…