LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3
Default question best way to organze data for this chart

Have product sales data spreadsheet that I need to produce chart for sales
presentation.
Data includes sales transactions spread over several months. Sample:

Transaction 1 - July 20 $12,000
Transaction 2 - July 25 $25,000
Transaction 3 - Aug 1 $35,000
Transaction 4 - Aug 20 $15,000 etc

We have several sales per month at different prices. We'd like to show bar
chart by month for sales in groups of $10,000 increments. So each month
there should be bars for sales in these ranges:

$10,000 - $19,999
$20,000 - $29,999
$30,000 - $39,999 etc.

There would be a bar for each group above with the height controlled by
number of sales in each price category that month) and would like the total
of those sales to appear on the bar and the total number of transactions -
how many sales in that category) at the top of that bar. This would repeat
for each month being included. I can manually grab the numbers and place in
new chart and annotate the totals and count but wondiering how much of that
can be automated/done from the chart wizard or options.

Summary:
if we had 3 sales in one month in the $10,000 - $19,999 range, that bar
would be 3 units tall
if we had 4 sales in one month in the $20,000 - $29,999 range, that bar
would be 4 units tall
if we had 2 sales in one month in the $30,000 - $39,999 range, that bar
would be 2 units tall

Thanks.


 
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
Pivot Chart Data Label Format Question Dominic Excel Discussion (Misc queries) 3 March 1st 06 07:57 PM
Adding Data Information to a Chart Mike M Charts and Charting in Excel 4 December 17th 05 12:12 AM
Activating a Chart object Hari Prasadh Charts and Charting in Excel 6 August 2nd 05 07:22 PM
Help with data not getting plotted Scott Ehrlich Charts and Charting in Excel 1 January 23rd 05 05:15 PM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 05:55 PM


All times are GMT +1. The time now is 07:54 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"