'Home' sheet with graphs

[Dylan]

Hi all,
At present, I produce monthly reports for non-IT folk, comprising
several sheets with a 'home' sheet that allows users to navigate like a
webpage, clicking underlined text for relevant data. What I'd like to be
able to do is include dynamically-updated graphs from the other sheets, to
get an at-a-glance view for the month.

Is this possible? If so, how?


TIA

Dylan

 

[Debra Dalgleish]

You can create charts from the data on the other sheets, and locate the
charts on the home sheet. For information on creating charts for a
specific date range, see Jon Peltier's article on Dynamic Charts:

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=246