Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 20th 07, 09:25 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2007
Posts: 3
Default Grouping before entering into a chart

Is there a way of grouping data before using it in a graph.
I have data as follows


Red 2
Green 3
Red 1
Blue 1
Green 3


What I am after is for the graph to show three entries Red 3, Green 6, Blue
1

Any help would be apprieciated

Tony


PS. It's just for my sons football team scores - I just need to show how
many goals in each set of matches in a group



  #2   Report Post  
Old November 20th 07, 11:54 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 2,489
Default Grouping before entering into a chart

Hi,

The chart will not group the data for you. You would need to determine those
values using formula or pivot tables.
I think in your case PT would be overkill. Instead use the following
formula.

Assuming your data is in A1:B5 enter the colours in D13

D1: =Red
D2: =Green
D3: =Blue

In E1 enter this formula and then copy down to E2:E3

E1: =SUMIF($A$1:$A$5,D1,$B$1:$B$5)

You can now create a pie chart on the range D1:E3

See these 2 articles for more information on pies and zero suppress.

http://pubs.logicalexpressions.com/P...cle.asp?ID=390
http://pubs.logicalexpressions.com/P...cle.asp?ID=471

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Tony" wrote in message
...
Is there a way of grouping data before using it in a graph.
I have data as follows


Red 2
Green 3
Red 1
Blue 1
Green 3


What I am after is for the graph to show three entries Red 3, Green 6,
Blue 1

Any help would be apprieciated

Tony


PS. It's just for my sons football team scores - I just need to show how
many goals in each set of matches in a group





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
Grouping dates in PivotTable/Chart Heidi Charts and Charting in Excel 1 January 25th 06 02:27 AM
Grouping Kay Excel Discussion (Misc queries) 1 January 21st 06 02:24 PM
Grouping of chart. ramkumar_cpt Charts and Charting in Excel 0 November 29th 05 02:50 PM
After grouping & ungrouping a chart, I can no longer format it? Pro_D Mike Charts and Charting in Excel 0 October 5th 05 08:01 PM
grouping MINAL ZUNKE New Users to Excel 4 June 29th 05 04:36 PM


All times are GMT +1. The time now is 03:14 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017