+ Reply to Thread
Results 1 to 3 of 3

Filled Radar centralization at 0.0

  1. #1
    Registered User
    Join Date
    12-09-2014
    Location
    Leeds
    MS-Off Ver
    2013
    Posts
    2

    Filled Radar centralization at 0.0

    Radar.xlsx

    Hi,

    I was hoping someone could help me please.

    I have a number of questions that have answers based on a scale of 1 to 4

    These answers then link to a filled radar with 0 in the middle and 4 on the outside

    The colour is faded in the middle and then gets darker towards the outside

    Everything seems to work fine except the colour is centralized around the middle of the results and not 0,0 as I would like

    Any ideas how to correct this?

    Many Thanks

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

    Re: Filled Radar centralization at 0.0

    That's how the gradient fill works, you can not offset the center of the fill.

    Better to remove the gradient fill completely.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    12-09-2014
    Location
    Leeds
    MS-Off Ver
    2013
    Posts
    2

    Re: Filled Radar centralization at 0.0

    ah okay I was worried that might be the case after spending a while going through the options

    Thank you for confirming - much appreciated

+ 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. Count filled and empty cells from the first filled cell in a row
    By mdaoust in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-01-2014, 01:23 PM
  2. Radar Chart that is filled in showing quarter progress
    By slinskey in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-06-2013, 09:47 AM
  3. Replies: 12
    Last Post: 07-10-2012, 05:04 PM
  4. Data extraction and centralization
    By alinm in forum Excel General
    Replies: 1
    Last Post: 10-05-2011, 03:30 AM
  5. Filled radar chart with multiple series
    By MSP77079 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-02-2007, 08:43 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