custom radar chart w/multiple axes

amf7

New Member
Joined
Feb 19, 2010
Messages
1
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 tab, I get an error dialog box titled "Add-in TM Custom Radar disabled". The error messages says:

"TMCustomRadar (TM Custom Radar:AddRadarChartRow) Err: Subscript out of range (9)"

When I click OK, the TM tab shows an icon for the custom radar chart, but it's greyed out. My Excel 2007 Trust Center settings for Add-ins has all boxes unchecked (i.e. I left the box unchecked for "Disable all Applications Add-ins).

Has anyone else been able to get this add-in to load? (The TM web site says they can't help much with security settings, and Microsoft Pay-for-Support says they won't help with add-ins.)

Thanks.
 

Some videos you may like

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

zandive

New Member
Joined
Jun 30, 2010
Messages
2
Hi,

I am having the same problem described above. Were you ever able to resolve this? Has anyone else encountered this error? I haven't been able to find any information via Google, other than this thread.

I have set all Trust and Add-in settings as described at http://www.tushar-mehta.com/excel/software/installation/, deleted the Add-in and reinstalled it, all to no avail. I am using Excel 2007 and the "TM Custom Radar 2007.xlam" file. I've also tried on two different computers, but get the same error. The error message is identical to what amf7 mentioned above. Any help would be very much appreciated!

Thanks,

zandive
 

zandive

New Member
Joined
Jun 30, 2010
Messages
2
Problem solved:

When using Excel 2007, make sure both the ".xlam" and ".xla" files are properly installed and activated. If just the ".xlam" file is installed, the TM tab will be visible but throw the error when it is clicked on.

zandive
 

Watch MrExcel Video

Forum statistics

Threads
1,101,810
Messages
5,483,040
Members
407,375
Latest member
achusp

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top