Grouping data into ranges

K

krjacobs32

Hi,

I have a data set of prices in a Pivot Table that is organized by the
Count (thanks to Tushar!). How would I be able to graph the totals
according to price range? For example, I would like to graph the
percentage of cost that each price range contributes to the total,
i.e., those that include all prices between $5-6, $6-7, etc. Below is
an excerpt:

Count of $12,458.75
$12,458.75Total
$5.35 1
$5.90 3
$6.10 1
$6.60 3
$6.99 3
$7.32 1

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top