Chart is a tool which is used in MS Excel for communicating the data graphically. With charts you can see the meaning of of each number in the spreadsheet. With charts you can show the comparisons as well as trends easily. In the following tutorial you will learn how to work with charts in MS Excel 2007. You can also learn about Slide Master View in MS PowerPoint 2016.
Creating a Chart:
In order to create a chart you need to follow these simple steps.
- 1st of all you need to select the worksheet which you need to work with.
- Now you need to select the cells which you want to chart. This include the column titles and row labels.
- Now you are required to click on Insert tab.
- Now you need to hover over the Chart options in the Chart group in order to learn more about it.
- Select one of the Chart options.
- Select the type of chart from the list that appears.
Parts of the Chart:
Charts are actually the visual representation of the data in a worksheet. Charts will make it very easy to see comparisons, patterns and trends in the data. The parts of the chart are as follows.
Title: It is the title of the chart.
Legend: It is the chart key which will identify what each color on the chart represents.
Axis: Axis is the vertical or the horizontal parts of the chart. The vertical axis is often referred to as the Y-axis and the horizontal axis is referred to as the X axis.
Value axis: Value axis is the axis that represents the values of the source data.
Category Axis: the axis the identifies each data series.
Chart Tools:
Once you are inserted the chart you will notice a new set of Chart Tools which are arranged into three tabs will appear above the Ribbon. These tools will only appear when the chart is selected.
Changing the Chart Type:
In order to change the chart type you need to follow these simple steps.
- 1st of all select the Design tab.
- Now click on the Change Chart Type command. You will notice that a dialog box will appear.
- Now select another chart type.
- Click on OK.
Changing the Chart layout:
- 1st of all you need to select the Design tab.
- Now locate the Chart Layouts group.
- Click on More arrow in order to view all of your layout options.
- Now left click on the layout in order to select it.
Changing Chart Style:
- Select the Design tab.
- Now you need to locate the Chart Style group.
- Click on the More arrow in order to view all of your style options.
- Left click on the style in order to select it.
Moving the Chart to a Different Worksheet:
- 1st of all select the Design tab.
- Now click the Move Chart command and you will notice that a dialog box will appear. The current location of the chart is selected.
- Now you need to select the desired location for the Chart.