Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
consolidation of tables in excel with text and figures samenvoegen van sheets Excel Worksheet Functions 8 March 2nd 06 03:27 PM
2 DATA RANGES IN CHARTS Maria Charts and Charting in Excel 1 November 23rd 05 12:37 AM
excel spread sheet wont caculate new data entered in ranges. Art-needs-help Excel Discussion (Misc queries) 3 November 8th 05 02:06 PM
In a 2 Y-Axis chart, how do I assign data ranges to an axis? Claire4Golf Charts and Charting in Excel 1 September 28th 05 07:52 PM
Named dynamic ranges, copied worksheets and graph source data WP Charts and Charting in Excel 1 November 28th 04 05:19 PM


All times are GMT +1. The time now is 06:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"