zooming?

[clueless88]

Hi
Is this the term i should use?

I have trying to enable my chart to have a zoom effect.
My x-axis is based on date(time). How can i zoom in the
the lastest period of time say 60 days, or zoom out to
more than a year.OR even go back to a previous date range
like 3 months to 4 months back?

 

[Andy Pope]

Hi,

An alternative term would be dynamic.

You need to use named ranges to control the data you want to chart.
Check Jon Peltier's example. He also has links to other sites.
http://peltiertech.com/Excel/Charts/DynamicColumnChart1.html

Cheers
Andy

 

[clueless88]

Thanks, it certainly please my boss.

-----Original Message-----
Hi,

An alternative term would be dynamic.

You need to use named ranges to control the data you want to chart.
Check Jon Peltier's example. He also has links to other sites.
ml

Cheers
Andy


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
.

 

[Jon Peltier]

I have a fancier example in this article:

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

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

 

[Brian Murphy]

I'm not sure if it will work with a "time" axis, but you can try my Chartool
utility to see if it will do what you want.
www.xlrotor.com/chartool.zip

Cheers,

Brian Murphy
Austin, Texas