radar chart

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top