+ Reply to Thread
Results 1 to 2 of 2

Fix color of a series in Chart

  1. #1
    Registered User
    Join Date
    02-12-2015
    Location
    Atlanta, GA
    MS-Off Ver
    2014
    Posts
    3

    Fix color of a series in Chart

    I am trying to fix color of data series in Line chart, but couldn't find an option.

    Here is the requirement
    1. I have product profile margin (%) by region
    2. Each region has it's own profit margin goal
    3. I show one region (goal and profit margin %) at a time using line chart

    Here is an example:

    -------------------------------------------------------------------
    Region: NE
    Product: Prod1
    Margin: March - 2%; April - 9%; June - 11%

    Region: NE
    Product: Prod2
    Margin: March - 5%; April - 9%; June - 5%

    Region: NE
    Product: Prod3
    Margin: March - 5%; April - 8%; June - 9%

    Region: NE
    Product: Goal
    Margin: March - 4%; April - 10%; June - 8%

    ----------------------------------------------------------------------

    Region: SW
    Product: Prod1
    Margin: March - 5%; April - 9%; June - 11%

    Region: SW
    Product: Prod4
    Margin: March - 2%; April - 11%; June - 15%

    Region: SW
    Product: Goal
    Margin: March - 6%; April - 8%; June - 12%

    --------------------------------------------------------------------------

    I filter the region (select one at a time) on pivot chart and it shows the line chart correctly. The issue is that excel changes the "Goal" line color each time. I want to fix it so it always use the same color for "Goal" line when I select the region. Is it possible?

    Thanks,
    WC

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,441

    Re: Fix color of a series in Chart

    You will probably have to use VBA in the PivotTableUpdate event to fix the colour of the Goal Series

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

+ 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. Set chart series color to match series legend entries font color
    By Equipoise in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-03-2013, 07:33 AM
  2. Bubble Chart - Different color per series
    By Nadine Klug in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-16-2012, 09:51 AM
  3. Format color of Series in a chart
    By ekomsky in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-04-2012, 04:00 PM
  4. changing series color within a chart
    By lmigarci in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 06-03-2008, 02:00 AM
  5. help me to change the color of two series in a chart into the same
    By KhanhNguyen in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-20-2006, 11:48 PM

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