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 |
All times are GMT +1. The time now is 04:42 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com