Dynamic Series

[marion riva]

Hello,

I got question on Dynamic charting. I have data series in
rows that can vary, for instance they can increase or
decrease in the number of series. The problem i am having
is that the series do not graph dynamically, that is not
representing the current number of series.

It seems like remembers the prior number of series, for
instance, 3 series, and when I retrieve 5 series on same
data range it only graphs 3 series and left the other 2
out.

Is there anyway to fix this chart behavior for these
series?

any help will be appreciated, thanks a lot.

marion

 

[Jon Peltier]

There is some simple VBA code on my website for creating charts and
adding series.

http://www.geocities.com/jonpeltier/Excel/ChartsHowTo/QuickChartVBA.html

Why is it necessary to completely redraw the chart every time? What
additional features are dependent on the changing series?

- Jon