+ Reply to Thread
Results 1 to 5 of 5

Pivot Chart with selected columns

  1. #1
    Registered User
    Join Date
    09-08-2016
    Location
    Canada
    MS-Off Ver
    Office 2010
    Posts
    95

    Pivot Chart with selected columns

    Hello All,

    This might been asked before and i apologise in advance it it has, however here goes...

    Is there a way to create a pivot chart just using selected columns from the pivot?

    In this case, based on the attached file, can I create a pivot chart with just the following columns below that changes as I filter by approver?

    Site
    Site Name
    MAX
    MIN

    Thanks!
    Attached Files Attached Files

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,080

    Re: Pivot Chart with selected columns

    No- a pivot chart uses all the data in the pivot other than the grand totals (unless it's a pie chart). You could create a second pivot table that doesn't show the month and use that for your chart?
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  3. #3
    Registered User
    Join Date
    09-08-2016
    Location
    Canada
    MS-Off Ver
    Office 2010
    Posts
    95

    Re: Pivot Chart with selected columns

    Thanks xlnitwit.

    I need too have the months in there as a reference.

    Thought there might be a way to do it, but looks like it might be difficult or impossible.

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    5,589

    Re: Pivot Chart with selected columns

    Perhaps this will help.
    1) Link the Site names in the pivot table to column L.
    2) Use Name Manager and OFFSET to create a dynamic chart as per this article.
    OFFSET formula in Name Manager > Refers To: =OFFSET(Pivot!$J$7,0,0,COUNT(Pivot!$J$7:$J$81),1)
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  5. #5
    Registered User
    Join Date
    09-08-2016
    Location
    Canada
    MS-Off Ver
    Office 2010
    Posts
    95

    Re: Pivot Chart with selected columns

    Thank you JeteMc.

    I will definitely try it and let you know.

    Regards.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1