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...
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...
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...
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...
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...
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...
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...
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...
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 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.