T
tshad
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
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