Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
numbers on chart axis showing twice | Charts and Charting in Excel | |||
Making a chart from Row of numbers | Excel Discussion (Misc queries) | |||
Creating a chart with text not numbers | Charts and Charting in Excel | |||
Move gridlines in a chart so that they are above the numbers | Charts and Charting in Excel | |||
X Axis:Change Numbers on Chart ? Please Help! | Charts and Charting in Excel |