+ Reply to Thread
Results 1 to 1 of 1

Pivot Chart Color Change (from Pivot Filter)

Hybrid View

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

    Pivot Chart Color Change (from Pivot Filter)

    Hello,

    I've created a Pivot Chart linked to a Pivot Table.
    I set a Filter in Pivot Table which could basically have only two possible values.
    I'd like to change the chart bars color depending from the Pivot Filter Value.
    i.e. while Filter = 1 --> red bars in Pivot Chart; while Filter = 2 --> blue bars in Pivot Chart;
    Is there any chance to do this?

    Thanks in advance
    Regards
    Last edited by BrianAll; 08-31-2017 at 02:35 AM.

+ 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. pivot chart changed to normal chart after populate it in userform
    By farrag in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-09-2017, 09:12 AM
  2. Replies: 3
    Last Post: 03-24-2016, 01:49 PM
  3. Chart order in trad. Pivot Chart vs. PowerPivot chart
    By mr_jules in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-06-2015, 11:17 AM
  4. Changing a pivot chart column color based on the pivot table category
    By Shawne in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-08-2014, 09:12 AM
  5. How to add target line to stacked column pivot chart chart
    By oleg mirzaev in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 11-04-2013, 07:46 AM
  6. Replies: 2
    Last Post: 05-24-2013, 03:58 PM
  7. Replies: 3
    Last Post: 09-11-2010, 06:55 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