Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Suppose I have a spread sheet that looks something like this...

Excel Data

Now, I'd like to create a column chart that has 3 series, one for each country. Then, I want series for each category, but I want to plot the total, not each individual order total. So, something like this (excuse the horrible artwork)...

Excel Chart

The data label placement isn't all the important, the key is that for each Category (Bikes and Clothes) I chart the total for each country, not individual values from the "Order Total" column.

Is this possible? Is it possible to do the same idea, but to switch Country and Category around?

share|improve this question

2 Answers 2

Pivot tables and pivot charts are perfect for this purpose. They'll let you summarise your data into a table and chart and to easily reorganise both of them.

share|improve this answer
    
Yes, but i'd really like a regular chart unfortunately. –  Chaulky Jan 6 '11 at 0:55
1  
@Chaulky: I don't think it can be done any other way. If there is an alterative you'll probably find it to be so complicated as to outweigh any disadvantages you perceive pivot charts having over normal charts. Hopefully some can enlighten us both. :) –  Mike Fitzpatrick Jan 6 '11 at 1:14

You may want an array formula (I found it by looking for "double sumif()") which essentially lets you specify more than one criteria for the IF part.

See this page for more information: http://www.cpearson.com/excel/ArrayFormulas.aspx

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.