Selecting data to display as a chart


show more Selecting data to display as a chart provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2007: Charts in Depth show less
please wait ...

Selecting data to display as a chart

Many Excel users are surprised, after creating their first chart, how easy it was, and if you haven't created a chart before, I think you're going to be surprised. There are some great shortcuts. There are some easy ways to do this. But no matter how create a chart, the first step is always thinking about which data it is you'd like to see portrayed in the chart and then actually selecting that data. As we look at the two sets of data here on this worksheet called Chart Data, actually it's the same data, just aligned differently. Let's focus on the top portion rows 4 through 11.

I've highlighted in green, not necessarily the required area, but let's say the area that we'd be most interested in, and right away you might be thinking, "Well, that's a mix of numbers and text. How is this all going to work." You certainly can create a chart by first selecting any data you want. But if I were to select just this data here, and right away you might b...

Selecting data to display as a chart
Video duration: 6m 17s 3h 36m Intermediate

Viewers:

Selecting data to display as a chart provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2007: Charts in Depth

Subject:
Business
Software:
Excel
Author:
please wait ...