When to use Area, Scatter graphs?



0
You did not teach when and how to use scatter and area graphs. Could you please explain this?

3 Answer(s)


0

Scatter charts are commonly used for displaying and comparing numeric values, such as scientific, statistical, and engineering data. You should use a Scatter chart if you want to change the scale of the x-axis, or make it a logarithmic scale

0

-- Area charts
These can be used to plot change over time and draw attention to the total value across a trend. By showing the sum of the plotted values, an area chart also shows the relationship of parts to a whole.

-- XY (scatter) charts
Data that's arranged in columns and rows on a worksheet can be plotted in an XY (scatter) chart.
A scatter chart has two value axes: a horizontal (x) and a vertical (y) value axis. It combines x and y values into single data points and shows them in irregular intervals, or clusters.

Scatter charts are typically used for showing and comparing numeric values, like scientific, statistical, and engineering data.

0

XY (Scatter) charts
An xy (scatter) chart shows the relationships among the numeric values in several data series, or plots two groups of numbers as one series of xy coordinates.

Area charts
An area chart emphasizes the magnitude of change over time.

Your Answer

Click on this code-snippet-icon icon to add code snippet.

Upload Files (Maximum image file size - 1.5 MB, other file size - 10 MB, total size - not more than 50 MB)

Email
Password