Solved

Group same values in Excel Chart Legend

Posted on 2011-02-14
4
963 Views
Last Modified: 2012-05-11
Hopefully this is an easy question. I have a simple pie chart in excel, with a legend. The legend data series contains only 4 values. Let say Spring, Summer, Fall Winter. But I have more than 4 rows of data. The legend displays an entry for each value in each row. Is there an easy way for it to only show the 4 values, and add up the weights on the pie chart?

Thanks!
0
Comment
Question by:TheBigDog
4 Comments
 
LVL 6

Accepted Solution

by:
andreyman3d2k earned 50 total points
Comment Utility
I am not 100% sure what you mean, but if I understand correctly, you can apply the subtotals feature on your table, then graph it. Attached file.

Use the little number icons on the upper left to expand/collapse the data. The chart will reflect whatever is displayed.

Andrey
Subtotal-chart.xlsx
0
 

Author Comment

by:TheBigDog
Comment Utility
Yes thats exactly the chart I want to have. The problem is the subtotal data is hidden. I would like to print the summary for the chart, but still retaining on the detail of the data.
0
 
LVL 24

Expert Comment

by:broomee9
Comment Utility
This question has been classified as abandoned and is being closed as part of the Cleanup Program. See my comment at the end of the question for more details.
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

A2 = A1 That kind of cell reference is relative.  If you copy it from A2 to B2, then B2 will get this: B2 = B1 That's all fine and good, but if you then insert a new row above row 2, you'll find: A3 = A1 B3 = B1 This is intentional. …
Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now