+ Reply to Thread
Results 1 to 3 of 3

Pivot chart changing color for the series (lines)

  1. #1
    Registered User
    Join Date
    11-30-2017
    Location
    London
    MS-Off Ver
    2010
    Posts
    5

    Pivot chart changing color for the series (lines)

    Hi,

    I have such problem and it is very time consuming to format everything properly.

    I want to create few pivot charts with the same scheme color for each of them. So for example I have the same color on each graph for London( purple), Paris( green), Lisbon( blue). Colors are important in this case and I can't change them into anything different, so I can't use any built in scheme.

    For me the best solution would be if i can have, for each city color in the column and pick it up in some settings to take the color from this column.

    I know that there is the such option in SSRS, but I am wondering if there is any similar option in Excel 2010 or any good solution instead of macro ?

    Thank you for any response.

    Example:
    Table:

    City Color Value Month
    London purple 1.2 1
    Paris green 2.5 1
    Lisbon blue 3 1
    London purple 0.9 2
    Paris green 2.6 2
    Lisbon blue 3.2 2
    London purple 1.5 3
    Paris green 2.4 3
    Lisbon blue 2.8 3pivot chart.png

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,726

    Re: Pivot chart changing color for the series (lines)

    Have a read of link.
    https://peltiertech.com/pivot-chart-formatting-changes/

    In general, with Pivot Charts, you have less option to control formats and many techniques utilized in regular chart can't be used.
    “Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.”
    ― Robert A. Heinlein

  3. #3
    Registered User
    Join Date
    11-30-2017
    Location
    London
    MS-Off Ver
    2010
    Posts
    5

    Re: Pivot chart changing color for the series (lines)

    Thank you for response.

    I think in my situation the best solution to this problem is create color scheme for pivot chart once and the save it as template by clicking on the chart -> Pivot Chart Tools -> Design -> Save As template.

    And then i can use this template all the time, i can even share it with other people. It is not ideal, because it is coloring series by number, not name, but it saves a lot of my work.


+ 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: 03-05-2015, 05:30 AM
  2. 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
  3. Changing Marker Color on Series in Chart
    By Gary_C in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-28-2013, 12:20 PM
  4. 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
  5. Series/lines invisible on chart
    By gnoke in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-25-2010, 08:26 AM
  6. changing series color within a chart
    By lmigarci in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 06-03-2008, 02:00 AM
  7. [SOLVED] Changing Series Color
    By Eli Kedar in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-05-2005, 05:05 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