Spreadsheets - Chart Graphs
- Charts and Graphs
Produce different types of charts and graphs from spreadsheet figures
to analyze data, e.g. pie charts, column charts, bar charts.
Edit or modify a chart or graph: add a title or label, change the scale.
Modify the colors in the chart or graph.
To add a title to a chart · Click on the chart that you have created. You will notice that when the chart is selected the drop down menus change: I.e. the Data drop down menu is replaced by a Chart drop down menu.· Click on the Chart drop down menu, and select the Chart Options command. Make sure that the Titles tab is selected. Enter or modify a title as required. · Click on the OK button.
To change the chart scale · Click on an axis within a chart that
you have created, to select it. In the example shown we have selected
the vertical axis. · Double click on the selected item to display
a dialog box. Click on the required tab in the dialog box, in this case
Scale, as illustrated. · Modify the scale as required.
To modify the chart colors · Select an item, within a chart (by
single clicking on it), that you wish to change the color of. For example
in the illustrated show we have clicked on one of the vertical bars.
· Double clicking on the selected item will display a dialog
box, as illustrated. Make sure that in this case you select the Patterns
tab of the dialog box. Select the colors as required.
Change the chart type.
To use the Chart Type icon · Click on
the chart to select it, and click on the drop down arrow next to the
Chart Type icon on the Chart toolbar.· Select the new chart type
you require.
· Clicking on the Chart Type icon will display a drop down menu
containing a range of chart types, from which you can select the required
format.NOTE: When wishing to convert to a Pie chart you have to use
only one data series.