View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MJKelly MJKelly is offline
external usenet poster
 
Posts: 114
Default dynamic radar chart

Hi,

I have a radar chart which could be required to plot one, two or three
series of data. The number of points will be the same for each
series, but the number of points does vary.
I've set up and formatted a radar chart to show up to 3 series of 16
points. I then use some code to fill the series of data from another
worksheet. What I need help in doing is re-drawing the radar chart so
it is resized to reflect the number of points (anywhere between 3 and
16 points). I've tried using named ranges, but I'm not having much
luck. Can I not use some code to determine how many points have been
imported and then re-draw the radar chart to suit the range.

Matt