FORMATTING GRAPHS

CONTENT

1. Changing Chart Type
2. Adding and Editing Charts
3. Formatting a Chart

Changing Chart Type

After creating a chart, you can change it to the type you want. The type you choose depends on how you want to present your data.

1. Select the chart
2. Within the chart, click the right mouse button OR
3. Click on insert on menu bar
4. Click on change Chart type
5. Under Chart Type, list click to select the desired chart type (e.g, Column, Bar, Line, etc). Under Chart sub-type list, click to select the chart sub-typed desired. You can view the chart sample by pressing it and hold to view sample button.
6. Click on OK when satisfied.

Changing from histogram to pie chart using the same data

Adding and Editing Charts

Once you have created a chart, you can add more chart data series or copy additional chart data series from a worksheet or another chart. Microsoft Excel offers a variety of ways to edit your chart data

You can change a chart data series by:

1. Adding a chart data series to a chart
2. Adding or removing more data point to the existing chart data series.