Dynamic Charting But for a Stacked Colum Chart

[bruce]

Hi Excel charting Gurus,

I have been trying for 3 days to adapt the dynamic Charting examples
from Jon Peltier's and TechTrax (http://pubs.logicalexpressions.com/
Pub0009/LPMArticle.asp?ID=246)
But I Need to chart with a Stacked Column where the dates are stacked
along the X axis
Here is a link to what I am trying to do (www.jonson.ca/2Axis Not
Dynamic2.xls)

So that I do not have to make 12 charts, I want to allow the user to
pick a start and end dates (Via Sliders, That I get no problem!) and
have the chart update based on the selection. Basically I want the
functionality that is in the 2nd sample of the TechTrax article But my
poor little brain just can't work out how to modify this example to my
chart.

Any clues or examples would be very much appreciated

thanks in advance

Bruce

 

[Jon Peltier]

Post an image file to your web site, not a workbook, and I'll have a look.

- Jon

 

[bruce]

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

 

[Jon Peltier]

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.SetSourceData _
Source:=Worksheets("Sheet1").Range("MyDefinedRange"), PlotBy:=ByRows
End Sub

- Jon