The chart in excel present the data from your worksheet visually by representing the data in rows and columns as bars on a chart, for example, or as pieces of a pie in a pie chart. For a long time, charts and graphs have gone hand-in-hand with spreadsheets because they allow you to see trends and patterns that you often can’t readily visualize from the numbers alone. Which has more consistent sales, the Southeast region or the Northwest region?
Monthly sales reports may contain the answer, but a bar chart based on the data shows it more clearly.
Excel charts make it easy to turn your worksheet data into a chart. You can apply formatting, change the type, reselect the data, and add effects, such as a 3-D display. Special chart types allow you to display data for stocks and shares. You can print the completed charts on their own, or as part of the worksheet. In this lesson, you will learn how to create a basic chart.
The following information about share purchases and prices will be used for the purpose
of illustrating the Excel charting features:
• The total value of shares in a portfolio at the start of each year (to be charted).
• The individual prices of the shares on those dates (for calculations).
• The total number of shares held (constants, for simplicity).
(See Image Below)
⇒ To create a chart you can modify and format later, start by entering the data on a worksheet. Then select the data and choose the chart type.
⇒ If you let Excel choose the data, ensure there is a blank row and column between the data you want to plot and other data on the worksheet.
Select the Data
Some chart types, such as pie and bubble charts, require a specific data arrangement. For most chart types, however, including line, column, and bar charts, you can use the data as arranged in the rows or columns of the worksheet.
1. Select the cells that contain the data that you want to use for the chart (or click a
cell and let Excel select the data). (See Image Below)
2. Click the Insert tab, and then select a chart type (Column for example) from the
Charts group. (See Image Below)
3. Choose the chart subtype, e.g. 2-D Stacked Column (to show how each share
contributes to the total value).
4. The chart is superimposed over the data on the worksheet, and Chart Tools
(Design, Layout, and Format tabs) are added to the Ribbon. (See Image Below)
5. Click Move Chart, in the Location group on the Design tab, to choose where you want the chart to be placed. For example, choose New sheet to create a separate chart sheet with a default name of “Chart1” (See Image Below)
When you move the mouse pointer over any of the chart subtypes, you get a description
and an indication of when that chart subtype might prove useful. (See Image Below)