Excel chart type: Creating a variety of chart types

 

Excel chart type: YOUR OBJECTIVE

Your company’s product sales are summarized in an Excel table. Anticipating that a chart would significantly contribute to understanding this data, you now want to create a 3-D chart based on your sales data.In this learning module “excel chart type“, you will be shown how to choose and generate any of the various Excel chart-types, but in more detail, how generate a 3-D column chart.

Excel chart type: HOW DOES IT WORK?

The variety of excel chart types is very wide to choose from. First select the data for the chart. Make sure that you include row and column headings in your selection; otherwise the chart may not assign proper labels. In the current example, as you can see below, we will chart sales results for wine types sold in the first 3 quarters:

 

After selecting the data area, go to the Inserttab on the Ribbon. There, in the Charts group…

…you will see a partial catalog of the types of charts that are available:

 

Column: To compare several categories, a column chart is often a good choice. That is, you may want to use this type of chart if your goal is to compare the data in two or more rows or columns.

Line: A line chart is often suitable for observing how a data trend develops over a period of time. You may want to use a Line chart, for example, to graphically illustrate how a share price (stock market) develops over time.

Pie: A pie chart is quite good for comparing items that appear in a single row or column of data. A pie chart can show to what extent, in precent, each item contributes to the total.

Bar: Much like the column chart, this chart layout can also be used to compare data in several rows or columns. In this case though, the bars are oriented horizontally instead of vertically.

Area: An area chart emphasizes the differences between two or more sets of data over a period of time. It is similar to a line chart, but the spaces beneath the lines are filled with color.

Scatter: Also known as an x-y chart, this chart layout permits you to compare pairs of values.

Other: Here you can choose from other types of charts, such as Stock, Surface, Doughnut, Bubble orRadar.

Dialog box launcher: Opens the Insert Chart dialog box in which you can see and choose from all available chart layouts.

If you want to display your data as a 3-D Column chart, as we do in our example, click thebutton. The follwing catalog of column charts will appear:

 

In our example, you would select 3-D Column (as shown below):

 

Excel then inserts the chart as an object on the worksheet that contains the underlying data (table). Simultaneously, the Design tab under the Chart Tools context tab, opens in the Ribbon:

 

You can remove a chart at any time. To remove a chart, click the frame that surrounds the chart area and press [Del] or[Delete].

Excel chart type: HINT

If it happens that you don’t want to use the entire table’s data but only a specific data range as a basis for your chart, you can, with the help of the [Ctrl] key, select just the cell range or ranges that interest you. For example: select all row headers in column A and then, while pressing and holding the [Ctrl] key, select the data in column D. For proper labeling, make sure you select the column heading, if present, along with the data.

Excel chart type: CAUTION

Because a chart is linked to the underlying data in the table, if you change any data, the chart will automatically adjust to reflect the change.

Did you like it? Then share it or sign up!

You can share this article with your friends or sign up for our newsletter for further information.

Leave a comment

Connect with Facebook

*

Kein Banner zum Anzeigen