![]() To create the chart we highlight the range B3:B13 and select Insert > Charts|Line. The main difference is that you need to select Insert > Charts|Line.Įxample 2 – Create a line chart for the average income of a sample of people in their thirties by age based on the data in Figure 2. ![]() The process for creating a line chart is similar to that of a bar chart. a stacked bar chart instead of a side-by-side bar chart). You can also change the type of chart by clicking on the chart, selecting Design > Type|Change Chart Type and then choosing the chart type that you want (e.g. If instead of a chart of sales by city, you want a chart of sales by brand, you can click on the chart and select Design > Data|Switch Row/Column. the ratio of the length to the width) doesn’t change it is important to hold the Shift key down while dragging the corner. We can then resize the chart, making it a little smaller (or bigger), by clicking on one of the corners of the chart and dragging the corner to change the dimensions. To get the results displayed in Figure 1 we also needed to move the chart within the worksheet by left-clicking on the chart and dragging it to the desired location. Finally, you can add the title of the vertical axis by selecting Layout > Labels|Axis Titles > Primary Vertical Axis Title > Rotated Title. You can add the title of the horizontal axis in a similar manner by selecting Layout > Labels|Axis Titles > Primary Horizontal Axis Title > Title Below Axis and entering the word City. To add a chart title click on the chart, select Layout > Labels|Chart Title and then choose Above Chart and enter the title Marketing Campaign Results. The resulting chart is shown in Figure 1, although initially, the chart does not contain a chart title or axes titles. ![]() the data (excluding the totals) including the row and column headings, and select Insert > Charts|Column. The first step is to enter the data into the worksheet. We now demonstrate how to create a bar chart via the following example.Įxample 1 – Create a bar chart for the data in Figure 1. At any time you can click on the chart to get access to these ribbons. Use the Design, Layout and Format ribbons to refine the chart.the first type is a 2-dimensional side-by-side bar chart while the second choice is a 2-dimensional stacked bar chart. As usual, you can place the mouse pointer over the picture of any chart type to get a brief description of that chart type. Highlight the data range and select Insert > Charts|Column.Enter the data that you are charting into a worksheet.To create a bar chart execute the following steps:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |