Use FREQUENCY to get a summary of how many sales in each category
Make an XY chart of the resulting data.
Have a go and come back if you need more help
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

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