+ Reply to Thread
Results 1 to 2 of 2

Standard colors in Radar Graph

  1. #1
    Registered User
    Join Date
    12-11-2012
    Location
    bristol
    MS-Off Ver
    Excel 2007
    Posts
    40

    Standard colors in Radar Graph

    Hi,

    I have 2 pivot radar graphs. I added slicers to change the data. The first graph has only one line in it, the second graph has 2 lines (one of wich is the same line as in graph 1).

    I changed the standard colors to keep the lines te same color when I change data in the slicers. But here is my problem. The line in graph 1 is red (accent color #1). In graph 2 the same line is blue (accent color 2#) and the secondary line is red. I want the the first line in graph 2 (the same as in graph 1) to be red and not blue, can someone help me?

    Tnx.

  2. #2
    Registered User
    Join Date
    04-05-2016
    Location
    Netherlands
    MS-Off Ver
    2013
    Posts
    7

    Re: Standard colors in Radar Graph

    Probably the easiest solution would be to switch the order of the columns/row of the data in the pivottable.

    The way you describe it I would assume Graph 1 shows data in the rightmost column/lowest row. If you switch the data around the colours should correspond.

+ 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. find and replace non-standard colors
    By ammartino44 in forum Excel General
    Replies: 4
    Last Post: 03-19-2015, 05:09 PM
  2. [SOLVED] Plotting a standard bar graph on the same axes as a stacked bar graph
    By Shearwater in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 05-01-2014, 04:59 AM
  3. Radar graph questions
    By gamtnman44 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-18-2013, 03:53 AM
  4. Replies: 1
    Last Post: 10-20-2009, 03:15 PM
  5. Using colors outside the standard palette
    By S2 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-21-2006, 10:55 PM
  6. [SOLVED] radar graph
    By Russell-stanely in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-14-2005, 12:15 PM
  7. [SOLVED] Novice trying to sort the values on a radar graph
    By [email protected] in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-17-2005, 11:05 AM

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