Pivot Charts

[Jaffabfc]

Hi,

I am wanting to have 3 pivot charts that change automatically, but all showing different data.

So far i have my pivot showing
A = Months
B = Percentage
C = Sales
D = SIH (stock in hand)

I have a pivot chart working no problem for the first column which is percentage, i have tried creating another one and its just showing everything and all i want is the sales in the pivot chart nothing else.

I am controlling the pivot with Slicers but i dont think that makes any difference.

I have tried creating a seperate table to make the graphs work from but for example now we are in June the first graph will show data from Jan-June but the sales graph will show Jan-June and then just blanks and i dont want them to be on, i just want Jan-Jun.

HELP!!!

I could create seperate pivots but i would want the slicers to control all the graphs.

thanks

 

[kurtisw]

AFAIK you will need to setup a separate pivot table for each chart. The way I do it is setup my first table with all the information that I will need, add the the slicers and my first pivot chart. I name that worksheet “Base Pivot”. Copy the Base Pivot worksheet and name the new worksheet to the type of data I plan to display ie “Sales” and remove the rows and columns I don’t need. The slicers should be linked.

 

[Jaffabfc]

i get that, but what can i do about the graphs showing columns that no longer have any data on.

So 2015-18 would have jan-dec but this year would only have jan-june and then show 6 0's for months even though the actual cells show nothing.