Chart Types

Each chart type has different attributes which can be further customised for your data.
The type of chart you will use is normally determined by the type of the data although trial and error is often the best way to find the most suitable chart type.
It is best to choose a chart type that conveys the message in the simplest possible way.

Line and XY Scatter Charts

There is often some confusion with these two chart types.
Both these chart types can display their data in line or marker format.
An XY Scatter chart is often used when the x-values are numeric.
A line chart is often used when the x-values are text or dates.
Even when a line chart is used with numeric values the numbers are treated as text.

How to change the Chart Type ?

There are three ways you can change the chart type after the chart has been created.

The maximum number if series does ddepend on the chart type.
And some chart types also require a minimum number of series, for example high-low must have 3.

Make sure that your default chart is the one which you use most often.
The default chart is a 2D clustered column chart using the Office theme.
SS of default chart.

If you are creating a lot of charts, changing the default chart type can save you a lot of time.

You can change the default chart type to any of the chart types listed on the Insert Chart dialog box
It is even possible to use one of the charts from the Templates folder.
To quickly display the Insert Chart dialog box click on the Dialog Launcher button from the (Insert tab, Charts group).
Alternatively click on any chart type drop-down (Insert tab, Column) and choose All Chart Types.
Click the "set as default chart" option.