clvestin
02-16-2011, 08:16 PM
I can use a worksheet dynamic range in a SeriesCollection.Add statement.
However, the chart is plotted with a static range.
What is the command form for modifying the series itself to dynamically update.
I'll include a small workbook that will better illustrate my dilemna.
However, the chart is plotted with a static range.
What is the command form for modifying the series itself to dynamically update.
I'll include a small workbook that will better illustrate my dilemna.