View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
[email protected] bruce@jonson.ca is offline
external usenet poster
 
Posts: 2
Default Dynamic Charting But for a Stacked Colum Chart

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