excel charts

B

bojan0810

Hi all!

I know how to make charts etc... But I have a question.

Can I make chart (for this one I need pie chart) like this:

There are 15 products in 3 years. And I need to make pie chart for 3 years, but...

I want to make if I change somewhere year that it will use other data from that year, not year before.

For example. If I chose 2013 year, it will show data from 2013 year in pie, If I chose 2014, it will show data from 2014. etc
 
Top