Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
consolidation of tables in excel with text and figures | Excel Worksheet Functions | |||
2 DATA RANGES IN CHARTS | Charts and Charting in Excel | |||
excel spread sheet wont caculate new data entered in ranges. | Excel Discussion (Misc queries) | |||
In a 2 Y-Axis chart, how do I assign data ranges to an axis? | Charts and Charting in Excel | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |