Graphing Question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

gts3@hotmail.com - 02 Apr 2008 20:54 GMT

Greetings!

I am trying to graph a set of data in 'XY (Scatter)' and am running
into a problem I've never seen before.

There are only seven values for 'X' - numbers 0 through 6.
'Y' is a set of percentages ranging from '0.00%' to '13.00%'
I have about 7,000 of these pairs.

When I graph this, I am not of seeing the six discreet bands of
percentages that I would expect. For some reason, instead of graphing
the 'X' value, it is graphing the order that the 'Y' value comes in
the list.

Instead of graphing:

RATING INCREASE
4 3.0%
4 11.0%
6 1.0%
3 2.0%
5 0.0%
2 6.0%

Reply to this Message

Mike Middleton - 03 Apr 2008 00:37 GMT

gts3 -

Be sure that the X data are all numerical values, not text that looks like a
value.

If any of the X data are text, the XY (Scatter) chart defaults to Line,
using the X data as equally-spaced labels for the X axis.

You may be able to coerce X data from text to numbers by entering 0 (zero)
in a cell, copy, select the X data, paste special values add.

For more assistance, specify your version of Excel.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel

> Greetings!
>
[quoted text clipped - 19 lines]
> 5 0.0%
> 2 6.0%

Reply to this Message

one third - 03 Apr 2008 17:20 GMT

> gts3 -
>
[quoted text clipped - 6 lines]
> You may be able to coerce X data from text to numbers by entering 0 (zero)
> in a cell, copy, select the X data, paste special values add.

Mike, thank you very much! It didn't work, but it sent me in the right
direction.

I tried adding 0 several times, and multiplying by 1 (what I usually
do) to no avail. Because you said "be sure that the X data are all
numerical values", I looked for text in the numbers and found several
blanks. I turned them into 0s and viola', it worked!

Reply to this Message

Rate this thread: