Thanks:  0
Likes:  0

1. ## Omitting Radar Chart Axes

Hi,

I'm excited to have found this site and look forward to learning from it for years to come. I am a relatively new Excel user and have a question about radar charts (or spidergrams as I have sometimes seen them called.)

I want my information to be shown using a radar chart that may at times have up to seven axes. Sometimes, there are not always values for every axis and the radar chart plots these points as zero. Is there a way to design my chart to where if one of my values that is to be graphed is a zero or an error, then Excel will omit that axis and instead construct a radar chart without that axis?

I don't want to falsely represent these values as zero (when the problem is missing data) and omitting them would make the chart look so much cleaner. Any help with this would be much appreciated.

2. ## Re: Omitting Radar Chart Axes

Hello Crazy horse and welcome to the forum!!

I see that you have 2 options.

1) you can delete the entry / leave the data blank and this will show a Gap for that axis point.

2) you can use the N/A function and this will not plot a point for that

Here is an example of using an NA() function in a formula to hide data points in graphs:
How-to Plot Building Wall UR Value in an Excel XY Scatter Chart
http://www.exceldashboardtemplates.com/?p=1602

HOWEVER, if you use the NA() Function in a radar graph, it may misrepresent your data becuase although the line doesn't break, it now appears as though there is a data point at that axis point because the line crosses it axis. Check out this picture to see what i mean.

Please let me know if this helps.

thanks

Steve=True

3. ## Re: Omitting Radar Chart Axes

Thanks for your help Steve. Unfortunately, I needed an alternate solution due to the fact that there are a possibility of eight axes and the average user would only have inputs for three to five of them. Having that much empty space or having the line travel through the axes where there was no value reported would not be acceptable. Here is what I did instead.

I assigned a macro to a button that says "View Own Scenario"

Sub ViewOwnScenario()
'ViewOwnScenario Macro
Sheets("Own Graph").Select
Dim c As Range
For Each c In Range("h5:h11")
c.Rows.Hidden = IsError(c.Value)
Next c

End Sub

This directs me to another page which at first contains a table with all eight data points, but then hides the rows that don't have a value (which I have made NA()). I know this is a slow and somewhat dirty way to go about it, but it works. This is my first time using macros and VBA, please feel free to critique. Do you foresee any problems with this solution?

-Crazyhorse

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•