SpreadCE Help


Charts
To add a chart, use the Insert>Chart menu option to add a new chart sheet. Then use the Format>Chart menu option to display the dialog box that contains the following formatting options:
Type
Series
Titles
Axes
Legend


Chart type
The program currently supports the following chart types:

ColumnDisplays vertical columns whose heights correspond to the data values.
BarDisplays horizontal bars whose lengths correspond to the data values.
LineDisplays a line through points whose vertical positions correspond to the data values, the horizontal positions are evenly spaced.
PieDisplays a circle divided up into regions whose relative sizes correspond to the data values.
ScatterDisplays a line through points whose x and y coordinates are given by the data values.
AreaLike the line chart, but the area below the line is filled in, and the series values are stacked.



Chart series
This allows you to specify the data values to be used for each series. To add a new series, press the 'New...' button. To change an existing series, select it in the list box and then press the 'Edit...' button. To remove an existing series, select it in the list box and press the 'Delete' button.
Note that for Pie charts, only the first series will be displayed.
When entering or changing a series, you are prompted for the following information:

NameAn optional name that is used to identify the series in the list box. It defaults to 'Series1', etc.
Y valuesA reference to the cells that contain the data to be charted. You can specify more than one reference, separating them with commas, but they must all be from the same sheet. Alternatively you can specify this as an array of values.
X labelsFor Column, Bar, Pie, Line and Area charts, you can specify a reference or array of values that will be used to label the categories. As there is only one set of labels, this must be the same for all the series on one chart. For Scatter charts, this item is labelled 'X values' and you must enter a reference or array of values to be used as the x co-ordinates of the line.
Line colorFor Column, Bar, Line and Area charts, you can specify the color that will be used for the lines.
Area colorFor Column, Bar and Area charts, you can specify the colour that will be used to fill the interior.



Chart titles
This allows you to specify the titles that will be used to label the chart itself and the x and y axes. Note that axis titles do not apply to Pie charts.

Chart axes
This allows you to specify the formatting of the x and y axes. The actual options that are available will depend on the currently selected chart type.

AxisSpecifies whether the axis line will be drawn.
GridlinesSpecifies whether the guidelines will be drawn.
TicksSpecifies whether the axis tick marks will be drawn.
ValuesSpecifies whether the axis values will be displayed.
LogarithmicSpecifies whether a linear or logarithmic scale is required.
MinimumSpecifies the minimum value to be used on the scale.
MaximumSpecifies the maximum value to be used on the scale.
StepSpecifies the interval between the values on the scale.



Chart legend
This allows you to specify the whether and where to display the names that identify each series with its line and/or area color. For Pie charts, the information displayed will be the category names (from the 'X labels' entry in the series formatting dialog box), for other chart types it will be the Series names from the chart series list box.