Selecting the right chart type


show more Selecting the right chart type 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 the right chart type

Excel has quite a few different chart types. Get familiar with that term. You'll hear that a lot. Certainly the most common for many, many people are column charts. There is one below the data we see on this worksheet to the left. A line chart is to the right of it. Not all chart types are equally effective in showing the data in a meaningful way. Most Excel users agree that a line chart, for example like the one we're seeing here to the right of the data is best for showing a trend, although sometimes a column chart might work equally well for you.

Usually column and bar charts are probably better for depicting volumes or amounts of data. Other chart types might have special uses that make them effective with certain data collections, but despite the over 70 choices of charts available, I think it's really best to experiment with different kinds of charts until you get a little more familiar with the idea and what works best for you. On this worksheet of course, you do see quit...

Selecting the right chart type
Video duration: 8m 2s 3h 36m Intermediate

Viewers:

Selecting the right chart type 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 ...