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

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


wrote in message
ups.com...
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

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

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