Hi,

Plot empty cells will only work if the cells are truly empty. The spoke
of the radar will not be removed but the line between the adjacent
spokes will be broken.

If the cells contain formula then use NA() to represent empty cells.
This will not cause the line to break but instead the line line between
adjacent points is plotted and the marker is not.

Cheers
Andy

SimonR wrote:
I'm writing a macro that will allow users to input data and eventually the
macro will generate a radar graph. Different users will have a different
number of data points for the radar graph based on their input. When I setup
a radar graph to chart data from a certain range, I want the graph to only
plot cells with actual numbers in them and ignore empty cells. The options
under 'Tools-options-charts-plot empty cells as' has not been able to
solve the problem. Thanks for the help.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info