+ Reply to Thread
Results 1 to 7 of 7

Change Chart Pivot series Colour depending from Pivot Table Filter value

  1. #1
    Registered User
    Join Date
    06-19-2013
    Location
    Sheffield
    MS-Off Ver
    Excel 2013
    Posts
    84

    Change Chart Pivot series Colour depending from Pivot Table Filter value

    Hello,

    I have a Pivot table with one filter set.
    I'd like to execute an instruction for each value that I choose in the filter: i.e. If Pivot Filter = "a" then Chart Pattern = red.
    I've tried with the "Change Property" with Target.Address but when I change the value of the filter the worksheet doesn't feel the "change".
    I tried with a workaround: I set a cell outside of the pivot table equal to the Pivot filter value but the worksheet doesn't fell the change unless I enter in the cell and click enter.
    How can I solve it?

    Thanks
    Regards
    Last edited by BrianAll; 02-27-2018 at 03:50 AM.

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,560

    Re: "Feel the Change"

    Just a thought but does the Custom Views functionality offer anything?
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    06-19-2013
    Location
    Sheffield
    MS-Off Ver
    Excel 2013
    Posts
    84

    Re: "Feel the Change"

    Thanks Richard. I don't think it will help.
    I actually "only" need to change the Pivot Chart Series (Histogram) Colour depending from the value of the filter set in the Pivot Table...

  4. #4
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,236

    Re: "Feel the Change"

    title updated....
    Last edited by protonLeah; 02-27-2018 at 06:26 PM.
    Ben Van Johnson

  5. #5
    Registered User
    Join Date
    06-19-2013
    Location
    Sheffield
    MS-Off Ver
    Excel 2013
    Posts
    84

    Re: Change Chart Pivot series Colour depending from Pivot Table Filter value

    I actually "only" need to change the Pivot Chart Series (Histogram) Colour depending from the value of the filter set in the Pivot Table...

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,591

    Re: "Feel the Change"

    Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore requests by Administrators, Moderators and senior forum members regarding forum rules.

    If you are unclear about the request or instruction then send a private message to them asking for clarification.

    All participants:
    Please do not post a reply in a thread where a moderator has requested an action that has not yet been complied with e.g Title change or Code tags...etc. Thanks.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  7. #7
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,591

    Re: Change Chart Pivot series Colour depending from Pivot Table Filter value

    Thanks for the title change, members are now free to answer further

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 07-23-2015, 02:36 PM
  2. Replies: 5
    Last Post: 07-16-2015, 10:14 AM
  3. [SOLVED] How to USE """"" cells count """"" change font color
    By austin123456 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-09-2013, 06:14 AM
  4. Change "Parent" cell based on results of multiple "Children" cells
    By ccowman in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 12-14-2012, 02:33 AM
  5. Replies: 4
    Last Post: 05-02-2011, 08:31 AM
  6. Change second "|" sings into "" , third "|" into "" and fourth into ""...
    By wali in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-27-2008, 06:31 AM
  7. Replies: 3
    Last Post: 02-17-2006, 12:30 AM

Tags for this Thread

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