dot plot chart+chart wizard

[Guest]

Can one make a dot plot chart using chart wizard. This chart will have 40
data points. The Y axis will be split in the middle with the upper half being
"+" and the lower half being "-". The median line on Y will be "0".

The graph will demostrate the differences from one number compared to a
second number.

Thanks

 

[Jon Peltier]

If you mean a dot plot as described in this page and the links it contains:

http://peltiertech.com/Excel/Charts/DotPlot.html

then no, you can't make a dot plot directly from the chart wizard, but the
page above includes a link to a utility that will make them.

If you mean something different, describe what it looks like, or provide a
link to an example.

- Jon

 

[Guest]

Jon,

Near the bottom of the link you sent, has something similar BUT the
corresponding numbers (in my case it would be the difference between two
numbers) are on the Y axis, not the X. Also there would be no labels as to
each point being plotted. Let me see if I can get it to work using what you
sent me. SPSS is too compliacted for me and I am trying to gather a massive
comparison study between two laboratory instruments.

May contact you again later though. Martina

 

[Guest]

Hi Martina,

Yes - plot the data as three separate series and then format each series to
show +, - or 0 as its marked and set the line display to None.

 

[Guest]

Shane,
I sort of see where you are going with this but maybe I forgot to write that
there are 3 sets of numbers. The first series is from one lab, the second
series is from another lab, and the third series is the difference of the
two, hence some positive and some negative. It is the third series that I
want to do a dot plot.
Martina

 

[Guest]

Hi Martina,

Post a little dummy data because I'm not sure what your data looks like.
Are you saying that values above the Median are + and Below the Median - and
on the Median 0? And exactly what do you mean by the Median value will be 0?
The median is the half why point and that might or might not be 0.

 

[Guest]

Here is more detail on how to do this, suppose your data is like below:
Column B is on set of lab results, column C the second lab result, Column D
the formula =C2-B2 to calculate the difference
A B C D
Name Lab1 Lab2 Diff.
Test1 61 31 -30
Test2 87 47 -40
Test3 69 97 28
Test4 27 47 20
Test5 72 36 -36
Test6 15 6 -9
Test7 74 80 6
Test8 31 58 27
Test9 86 58 -28
Test10 1 61 60
Test11 70 60 -10
Test12 67 51 -16
Test13 53 43 -10
Test14 43 12 -31
Test15 18 42 24
Test16 15 67 52
Test17 89 77 -12
Test18 40 32 -8
Test19 58 49 -9
Test20 48 38 -10

Chart column A and D with a line chart.

Double-click the series and on the Patterns tab set Lines and Markers to
None, and on the Data Labels tab turn on Values. Click OK.

Double-click any data label and activate the Numbers tab, choose Custom and
enter the following format:

"+";"-";0