radar chart

  1. J

    Coloured segments on a spider plot

    OK, I'm a long time reader of MrExcel, great resource, but this has me stumped and I can't find anything here. How do I make a spider plot with filled in segments of different angles? What I am trying to do is make a spider plot for data which has 18 categories, called M1 through M18, in Office...
  2. M

    There has to be a better way...

    For weeks I've been trying to find a better way to make a Wind Rose Chart or a Spiral Bar Chart to keep track of my Achievements in Steam. I tried to ask AI-aided Formula Editor but it's either not working or I'm not asking the right questions. I'm trying to find a better way to write the...
  3. C

    How to correctly automate Radar Chart creation process in VBA?

    Hi everybody! So I'm a total noob and have never used VBA before but I'm trying to automate the creation of 'radar charts' for work. I have a table that looks like this: And I'm trying to automate the process of creating radar charts that look like this: So far I've written this: Sub...
  4. F

    Labels not showing for out of bounds data in radar chart

    Hi all I work for a small call centre, and part of my role is to manage the score cards. I have modified them using radar graphs, to visually show how close to each target the agent is. I have set the bounds from 0% to 200%. However, if an agent manages to do more than double the target (it...
  5. B

    Data label positions in a Radar Chart

    Hi I have created a radar chart in Excel that plots three data series, and have added a macro that adds data labels. At the moment the data labels are not well aligned to the data points plotted. Is there a way to align them consistently (e.g. to the right of the points plotted)? I have tried...
  6. REV AJR

    Radar Fill colour

    Please can any one help, I have created a Radar Graph uisng the following criteria <TABLE style="WIDTH: 192pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=255><COLGROUP><COL style="WIDTH: 109pt" width=145><COL style="WIDTH: 83pt; mso-width-source: userset...
  7. V

    Radar Chart Ring Color

    I would like to know how to color the rings of a radar chart, specifically only the outer one. I've seen a few postings on making these charts look like a target but have not been able to apply. I'm using the data set found at...
  8. E

    Hide zero or error values in radar chart

    Hi everybody, I am trying to hide zero or error values in a radar chart. When I google this topic, most answers go something like "replace =IF(a1>1;a1;"") with =IF(a1>1;a1;na())" This returns an NA# value instead of a zero. This solution might work in other chart types, but in my radar...
  9. W

    Draw Smooth Transparent Shapes on Radar Chart

    Hi guys, I have tried to run the code given to draw smooth transparent shapes on radar chart, as suggested by Peltier as shown in the website below. http://peltiertech.com/Excel/Charts/VBAdrawradar.html#SmoothTransShape I believe some of you should be an expert in handling the chartin...
  10. A

    custom radar chart w/multiple axes

    I'm looking for a custom radar chart w/multiple axes. I found an add-in here by Tushar Mehta: http://www.tushar-mehta.com/excel/software/custom_radar/index.htm However, while I can get the add-in installed as far as making my Excel 2007 ribbon show a new tab called "TM", when I select that...
  11. P

    Radar Chart - multiple axes with user defined scales

    Hi, Has anyone developed a radar chart whereby you can have multiple axes, multiple scales and specify which way the scale runs ? I am a VBA programmer but would rather receive a macro/add-in rather than develop it myself. Thanks Peter

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top