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

  • Timer in VBA - Stop, Start, Pause and Reset
    • Started by Anton1999
    • Replies: 28
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    • Started by jaym6939
    • Replies: 26
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    • Started by dpaton05
    • Replies: 24
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top