Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Scatter graph, how do I show overlapping points?
I have a scatter graph with a number of points that over lap. How do I show
them so that the reader can tell there are multiple points. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Scatter graph, how do I show overlapping points?
On Mon, 9 Apr 2007, in microsoft.public.excel.charting,
KieranMoran said: I have a scatter graph with a number of points that over lap. How do I show them so that the reader can tell there are multiple points. a) "Jittering", which is the name for putting a small random variation in the data to break up the exact values. Obviously you want it to be as small as possible while still exposing the hidden points b) a non-random variation, moving the hidden points exactly and systematically away from the first point and each other. This can create a pattern that lets you show the first point as the one which is on the right spot c) A different symbol for multiple points, 1, 2, 3 etc., with a legend to explain what the points mean d) a bubble graph, with the bubbles proportional in area to the number of overlapping points -- Del Cotter NB Personal replies to this post will send email to , which goes to a spam folder-- please send your email to del3 instead. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I chart missing data points in a scatter graph? | Charts and Charting in Excel | |||
Display count of data points in a scatter graph | Charts and Charting in Excel | |||
Connecting Points In An XY-Scatter Plot Graph | Charts and Charting in Excel | |||
How do i show duplicate data points on a scatter plot? | Charts and Charting in Excel | |||
graph does not show all plotted points | Charts and Charting in Excel |