Excel Question #46563789274

[StevieC]

I'd imagine this needs a Lookup but just wonder if there is an easier way:

 

Two columns, one with numerical values, the other with the category that corresponds to that value.

 

e.g.

 

Column1 Column2

500 category x

100 category y

1000 category z

 

 

There's about 6 thousand rows and 40 odd categories.

 

What I'd like to do is get a pie chart showing the cumulated value of each category.

 

So, do a look up to isolate all the values for that category and sum them, or is there a more convenient method?

[charlie clown]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

Edited August 20, 2012 by charlie clown

[MFletcher]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[StevieC]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[MFletcher]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[StevieC]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here