View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Ray Ray is offline
external usenet poster
 
Posts: 267
Default Help! Bullen's Scroll/Zoom chart

Hello -

I was lucky enough to run across Stephen Bullen's Scroll/Zoom a chart
(found he http://www.oaltd.co.uk/Excel/FunChrt7.zip) -- it's almost
exactly what I need. However, I'm hoping that someone can help me
modify this chart to really get me where I want to be ...

The charting technique that Stephen has allows users to Zoom/Scroll
through a lengthy set of data -- the data is setup so that one column
contains labels and one contains data, using OFFSET formulas to
control the Zoom/Sroll feature. What I want to do is have SEVERAL
columns make up my horizontal axis labels!

For instance, instead of just having '7/21/2008' as the label, I'd
like to also have 'Monday' beneath it, and 'July' beneath that
(spanning 31 entries).

I've seen the multiline axis labels in John Walkenbach's Excel Charts
book (p122-123), but haven't had any luck merging the two charting
techniques ...

Can anyone help me out?

TIA,
Ray