Hi tshad,

Format the Level column as text.

If you still want the Level data to appear as currency with the dollar sign
and 1000's comma, then in another column insert the formula below to convert
it to text and then you can Copy-Past Special-Values back over the original
data and then delete the column with the text formula.

=TEXT(A2,"$0,000")

I tested it and it works for me.

Regards,

OssieMac




"tshad" wrote:

I have a set of numbers:
Level Response
$250,000 1
$187,500 1
$75,000 1
$50,000 3
$46,857 1
$30,000 3
$21,000 1
$20,000 1
$18,750 1
$18,000 1
$15,000 1
$10,000 2


In this case, I have 1 response at 250,000 and 3 reponses at 50,000 etc.

What I am trying to do is chart this so that the Y axis is 0 - 250,000 (or
300,000) and the X axis is at 0, 1, 2 , 3.

What I get is the Y axis at 0 - 250,000 and the X axis at 0, 1, 2, 3, 4, 5,
6, 7, 8, 9, 10, 11, 12 (which are the cell numbers where 250000 is 1 and
187,5000 is 2 etc).

I am trying to show something like this:

250,000 xxxxxxxx
187,500 xxxxxxxx
75,000 xxxxxxxx
50,000 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
46,857 xxxxxxxx
30,000 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
21,000 xxxxxxxx
20,000 xxxxxxxx
18,750 xxxxxxxx
18,000 xxxxxxxx
15,000 xxxxxxxx
10,000 xxxxxxxxxxxxxxxxxxxx
1 2 3

The scatter graph shows the axis correctly and puts the points in the right
place, but the bar graphs don't.

Is there a way to make the bar graphs do this?

Thanks,

Tom