+ Reply to Thread
Results 1 to 1 of 1

radar chart filled with gradient at center point

  1. #1
    Registered User
    Join Date
    08-17-2011
    Location
    Bristol, England
    MS-Off Ver
    Excel 2003
    Posts
    35

    radar chart filled with gradient at center point

    Hi there

    I can't seem to find any answer to this (and actually don't know what really to call it). I've got a radar chart and want to highlight the different values with their equivalent RAG rating (e.g. 0-3 red, 4-7 amber, 8-10 green). I can get the plot area to what I want but not the data area (inside of chart). The problem is that if I fill with a gradient fill, the center point is the center of the data area, not the center of the axis, so red won't be from 0 to 3, it might start at the 1 position on the right if the chart is weighted on that side. Is there a way to fill with a radial gradient that maintains it's format, irrelevant of chart location? sorry for sounding confusing.

    This pic is kind of the inverse of what I'm after. I want the actual blue data area to be the gradient fill (as in the plot area)
    radar pic.gif

    Thanks
    Alan
    Attached Files Attached Files

+ 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. Filled Radar centralization at 0.0
    By fletch_n_1 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-10-2014, 09:05 AM
  2. Maths behind rotating rectangle around start point instead of default center point
    By Stanley91 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-08-2014, 11:01 AM
  3. 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
  4. Gradient fill a point with 2 general colors (excel 2010)
    By spacely in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-16-2012, 05:05 PM
  5. Filled radar chart with multiple series
    By MSP77079 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-02-2007, 08:43 PM
  6. [SOLVED] How do I get the gradient at a point on a curved graph?
    By utopian_sorceror in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-19-2005, 08:05 PM
  7. fill between two end values and a center point
    By golfcents in forum Excel General
    Replies: 1
    Last Post: 02-03-2005, 07:10 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