If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
cross office program data sharing | m_jurrens | General Discussion | 0 | December 16th, 2005 03:36 PM |
Unable to have multiple queries feeding a single report | PZ Straube | Setting Up & Running Reports | 15 | June 15th, 2005 08:16 AM |
Pulling data from 1 sheet to another | Dave1155 | Worksheet Functions | 1 | January 12th, 2005 05:55 PM |
Charting data ranges that change | mikelee101 | Charts and Charting | 2 | December 16th, 2004 11:07 PM |
Chart Source Data Ranges Changing when Data Sheet updated from text file source. | Tekn0 | Charts and Charting | 3 | January 8th, 2004 04:45 PM |