Hi Ossie,

I am not concerned with how the labels look.

What I am concerned with is how the bars look.

And also the X axis, which is going 0-12 instead 0 - 3.

What I am looking for is:

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

What I am getting is:
x
11 xx
xxxx
9 xxxxx
xxxxxx
7 xxxxxxx
xxxxxxxxx
5 xxxxxxxxxxxx
xxxxxxxxxxxxxxx
3 xxxxxxxxxxxxxxxxxxxx
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
1 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxx

$0 $50,000 $100,000 $150,000 $200,000 $250,000

This isn't even close to what I am looking for.

I did find out a way to make it work by putting it in 2 rows?

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

this gives me the following:

xxxxxxxx
187,500 xxxxxxxx
xxxxxxxx
50,000 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
xxxxxxxx
30,000 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
xxxxxxxx
20,000 xxxxxxxx
xxxxxxxx
18,000 xxxxxxxx
xxxxxxxx
10,000 xxxxxxxxxxxxxxxxxxxx
1 2 3

This is what I was looking for, but I don't know why I couldn't get it to work using the rows/columns.

Also, the Y-Axis doesn't show all the numbers, just every other one. Is there a way to get it to show all the numbers?

Thanks,

Tom

"OssieMac" wrote in message ...
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