LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 12
Default Can't get Bar chart to use my numbers

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
numbers on chart axis showing twice mary Charts and Charting in Excel 1 February 19th 07 06:31 PM
Making a chart from Row of numbers David Excel Discussion (Misc queries) 2 January 9th 07 01:31 AM
Creating a chart with text not numbers aj1152 Charts and Charting in Excel 1 November 10th 06 09:04 PM
Move gridlines in a chart so that they are above the numbers Tara Medway Charts and Charting in Excel 1 June 19th 06 11:21 PM
X Axis:Change Numbers on Chart ? Please Help! CWriter81 Charts and Charting in Excel 2 December 29th 05 02:01 PM


All times are GMT +1. The time now is 07:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"