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