You can use the macro-free dynamic range approach work to change the number
of points per series, but not the number of series in the chart. To change
the number of series, which sounds like your objective, you need some kind
of VBA. Not complicated, you can still use sliders or similar mechanisms to
define the entire range to be plotted (by defining first and last rows or
first row and number of rows), then use a macro like this:
Sub RedefineChartData()
Worksheets("Sheet1").ChartObjects(1).Chart.SetSour ceData _
Source:=Worksheets("Sheet1").Range("MyDefinedRange "), PlotBy:=ByRows
End Sub
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______
wrote in message
oups.com...
Hi Jon Thanks for replying
Here are two jpegs, One of the January chart I have built and one of
the data
www.jonson.ca/StackedColumnChartJanuary.JPG
www.jonson.ca/DataForChart.JPG
Thanks in advance for any help you can provide
Bruce