View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
krjacobs32
 
Posts: n/a
Default Grouping data into ranges


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!


--
krjacobs32
------------------------------------------------------------------------
krjacobs32's Profile: http://www.excelforum.com/member.php...o&userid=23520
View this thread: http://www.excelforum.com/showthread...hreadid=519525