How do I?

[daisy]

I was asked to create a scatter graph of # of transactions in a year under
discount bucket categories and then a second access that shows the cumulative
$$'s associated with those.

I have 5 categories for the discounts:
<0%
0-5%
6-10%
11-15%

15%

Can anyone help me?

 

[Bernard Liengme]

Can you give us a small example of the data and a bit more info?
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
REMINDER: These newsgroups are about to die. We will all meet again at
http://social.answers.microsoft.com/Forums/en-US/category/officeexcel

 

[daisy]

Sure here's an example:
Quarter - Q1'10
Year - 2010
Sales Order # 12345
List Price $500
Net Price $500
Discount 0%
Discount Category <0%