In this topic you will learn how to create a simple chart.
In order to create a chart, you must first highlight the data you want to plot. We will look at three different ways to highlight data:
Steps:
Highlight consecutive rows or columns:
Step 1Highlight consecutive rows or columns:
Highlight the first row in the range.
Hold down the [Shift] key and use your arrow keys to go up, down, or across.
In this example, we'll use the down arrow and then the right arrow.
Step 2
Press [Shift+Down].
Step 3Press [Shift+Down].
Step 4Press [Shift+Down].
Step 5Press [Shift+Down].
Step 6Press [Shift+Right].
Step 7Press [Shift+Right].
Step 8Press [Shift+Right].
Step 9Press [Shift+Right].
Step 10
Highlight the Entire Range:
Step 11Highlight the entire range:
Click and drag to highlight the data.
Step 12
Highlight non-adjacent rows or columns:
Step 13
Highlight non-adjacent rows or columns:
Highlight the first row or column in your range. In this example, select Columns A, C, and E.
Step 14
Holding down the [Ctrl] key, highlight the additional rows or columns in your range.
Step 15Holding down the [Ctrl] key, highlight the additional rows or columns in your range.
Step 16With your data highlighted, create a Pie chart.
Step 17Click the Insert tab.
Step 18Create a Pie Chart.
In the Charts group, select the down arrow under the chart heading and select a chart type.
Step 19Select the Pie of Pie chart (top row, third chart).
Step 20After completing this topic you are able to create a simple chart.