Pivot Charts
Results 1 to 3 of 3

Thread: Pivot Charts
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jul 2013
    Posts
    155
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Pivot Charts

    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

  2. #2
    New Member
    Join Date
    Jun 2019
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Pivot Charts

    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.

  3. #3
    Board Regular
    Join Date
    Jul 2013
    Posts
    155
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Pivot Charts

    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.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •