A chart is a tool you deserve to use in Excel come communicate data graphically. Charts permit your audience to watch the meaning behind the numbers, and they make mirroring comparisons and also trends much easier. In this lesson, you'll learn how to insert charts and modify them therefore they interact information effectively.

You are watching: Which group of the chart tools design tab is used to switch the rows and columns of a chart?

Charts

Excel workbooks deserve to contain a lot of data, and also this data can often be daunting to interpret. For example, where space the highest and lowest values? are the numbers boosting or decreasing?

The answers come questions favor these can become much clearer as soon as data is stood for as a chart. Excel has various types of charts, so girlfriend can select one that most effectively represents your data.


Optional: You can download this example for extra practice.

Types the charts

Click the arrows in the slideshow listed below to view instances of some of the types of charts easily accessible in Excel.

*

Excel has actually a selection of chart types, each with its very own advantages. Click the arrows come see few of the different species of charts accessible in Excel.

*

Column charts usage vertical bars to stand for data. They deserve to work with countless different varieties of data, but they're most typically used because that comparing information.

*

Line charts are appropriate for mirroring trends. The data clues are associated with lines, do it straightforward to watch whether values are increasing or decreasing over time.

*

Pie charts do it easy to compare proportions. Each value is shown as a slice of the pie, so it's basic to check out which values consist of the percentage of a whole.

*

Bar charts work as with column charts, yet they use horizontal rather of vertical bars.

*

Area charts are similar to line charts, except the areas under the lines space filled in.

*

Surface charts permit you to screen data across a 3D landscape. Castle work best with large data sets, permitting you to watch a selection of details at the same time.

See more: An Immense Body Of Air Characterized By Similar Properties At Any Given Altitude Is Known As

*
Identifying the parts of a chart

Click the buttons in the interactive listed below to learn about the various parts of a chart.