+ Reply to Thread
Results 1 to 3 of 3

Radar Chart - series chart type conversion issues

  1. #1
    Registered User
    Join Date
    10-16-2013
    Location
    NA
    MS-Off Ver
    Excel 2010
    Posts
    26

    Radar Chart - series chart type conversion issues

    Hello all,

    I presume radar charts aren't very common, so I'd be interested to hear some feedback on what could be happening here:

    Long story short, I created range colour scheme for my chart. The only way this can be done is to make the chart points be "lines" and not "fill". However, when it gets to the actual points I want to plot on the chart, I need the data to be "fill" instead of line. When I select the "stats" data series it gives me the option of changing the data series chart type. When I select "fill", it goes wonky and adds 1 more "invisible" dimension somehow that I can't seem to find diagnose or find. It changes the radar from the correct pentagon to a hexagon. See pics below and attached worksheet.

    Thanks in advance!

    ================radarbefore.JPGradarmiddle.jpgradarafter.JPGRadarChart series conversion.xlsx

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

    Re: Radar Chart - series chart type conversion issues

    The radar is a little buggy when mixing styles.

    Start with a filled radar for all 6 series.
    Move actual data series to secondary axis.
    remove Category labels and delete secondary value axis.

    Note the band values have changed.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    10-16-2013
    Location
    NA
    MS-Off Ver
    Excel 2010
    Posts
    26

    Re: Radar Chart - series chart type conversion issues

    Thank you sir!
    Works perfect!

+ 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. How to change a series chart type from Line to XY-Scatter
    By cartica in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 08-01-2014, 03:08 AM
  2. Radar chart series collection
    By EmmaEmu in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-13-2013, 12:28 PM
  3. Replies: 1
    Last Post: 09-02-2011, 08:57 AM
  4. Stock-type chart with 5 data series
    By josh83 in forum Excel General
    Replies: 2
    Last Post: 01-07-2011, 12:40 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
  6. [SOLVED] new time series chart type
    By Gklass in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-23-2006, 09:35 AM
  7. Excel x,y chart type x range must be re-entered each series
    By Thomas R. Glass in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-08-2006, 07:25 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