Sheet 146
To replace the current graph range (or ranges) with a new one:
1. In the Sheet view, highlight the new range you want the graph to use.
2. Switch to the Graph view, then press the Set ranges button. The new
range(s) will replace the old one(s) as the subject of the graph.
Adding a range to a graph
You can add further ranges to graphs to display additional information, e.g. to
include a previous year’s sales figures as well as the current ones.
To add a range to a graph:
• Select the range you want to add to your graph in the Sheet view,
switch to the Graph view and then select the command on the Ranges
menu.
Graph type & appearance
When you first create a graph, it will be a column graph. Change the type
using , or Graph settings. The graphs types include line graphs, bar
and column graphs, scatter graphs and pie charts.
To change the graph from 2D to 3D and back:
• Use the 3D button on the Top toolbar, or Graph settings.
To change the pattern used for a range:
• On the Ranges menu, select Change range, then choose the range and
the fill colours and styles for each range.
To change the background, text and line colours of a graph:
• Use the Colours and Styles pages in the Graph settings and Change
range dialogs.
Note! You can alter many aspects of the graph appearance by tapping on the
area of the graph you wish to change.
Adding titles, labels and grid lines
You can add titles, labels and grid lines.
To add a title to a graph:
• On the Graphs menu, select Graph settings and insert the title. You
can change the style and font of the title using Title font on the
Graphs menu.
To add axis titles:
• Use Format X-axis and Format Y-axis. You can also use these
commands to format the X and Y axes, e.g. to add grid lines, tick
marks, add or remove axis labels, alter the axis position and scale, or
hide them completely.
To add labels to each range:
• Use Change range to specify the type of label you want and the cells
in which your labels are stored.
To Next Page
Loading...