XY Scatter Chart Examples

image_pdfimage_print

The data in the sheet must be given in a certain order to get charts with correct values.

Example 1: Data grouped by rows

The x and y values have to entered one below the other as in screenshot below:

Data area for the chart: A1:B7
Chart type: XY (Scatter)
Data grouped by: Rows
Series labels: Auto
Category labels: Auto
Format numbers x axis: Percent
Format data series: changed colors
Entry for chart title: Turnover

Result: XY Scatter chart above.

Example 2: Data grouped by columns

The x and y values have to entered one after the other as in screenshot below:

Data area for the chart: A1:G2
Chart type: XY (Scatter)
Data grouped by: Columns
Series labels: Auto
Category labels: Auto
Format numbers x axis: Percent
Format data series: Changed colors
Entry for chart title: Turnover

Result: XY Scatter chart above.

image_pdfimage_print
Was this post helpful?
NoYes (-1 rating, 1 votes)
Loading...