Hi, I am hoping that someone can help me figure out how to accomplish this. I am trying to make a dashboard in a way. I need to have 11 graphs as follows: graph 1 is going to be over all sales for a category Example "Women's" that will have a slicer with it so they can pick what category they want to look at this one I know how to do and don't need help on this one. Graph 2-11 will be the subcategory this is were I need the help I need the 10 graphs to change with the main catagory then I need graph 2 to be the 1st item on the subcategory list then I need graph 3 to be the 2nd item on the subcategory list then I need graph 4 to be the 3rd item on the subcategory list and so on. When you change the Main category from the slicer all 11 graphs update. Is this possible? Please Help!!

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Pivot Graphs

Thread starter justvba
Start date Apr 5, 2017
Tags

excel 2016 piviot table pivot graph

justvba

New Member

Apr 5, 2017

Hi,

I am hoping that someone can help me figure out how to accomplish this. I am trying to make a dashboard in a way. I need to have 11 graphs as follows:

graph 1 is going to be over all sales for a category Example "Women's" that will have a slicer with it so they can pick what category they want to look at this one I know how to do and don't need help on this one.
Graph 2-11 will be the subcategory this is were I need the help I need the 10 graphs to change with the main catagory
then I need graph 2 to be the 1st item on the subcategory list
then I need graph 3 to be the 2nd item on the subcategory list
then I need graph 4 to be the 3rd item on the subcategory list and so on.

When you change the Main category from the slicer all 11 graphs update. Is this possible? Please Help!!