If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|