up vote 1 down vote favorite
share [g+] share [fb]

one representation of a row in my excel sheets looks like the following:

spec1, spec2, spec3, spec4, spec5, spec6, spec7, value

I have thousands of rows like this. What I would like to do is first say group by by spec1 and then by spec3 and then visualize the values or compare the values with other group by results.

How can I achieve it in excel without doing macro or visual basic programming? It is simple excel operations like group by being applied several times and visualizing the value columns graphically.

link|improve this question
2  
You're asking how to avoid programming on a programming Q&A site. – Chris Sep 18 '11 at 15:25
Well it is already being programmed inside excel, just asking for features that I could directly use out of box without doing programming. It is urgent, please help me – Bob Sep 18 '11 at 15:27
2  
I am not sure i really understand what you mean and what you intend to do. Maybe you could try a pivot table. – JMax Sep 18 '11 at 17:44
2  
JMax is right. You're going to need a pivot table to summarize the values (and a pivot chart to visualize them, if that's what you had in mind). Here's one of the thousands of online tutorials to get you started: contextures.com/CreatePivotTable.html – Excellll Sep 20 '11 at 13:45
For your case, I think you'll want spec1 and spec3 as your Axis Values, and value as the Values. – Excellll Sep 20 '11 at 13:46
feedback

migrated from stackoverflow.com Sep 18 '11 at 21:09

This question came from our site for professional and enthusiast programmers.

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
or
required, but never shown
discard