ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Zooming in chart by 2 click ?? (https://www.excelbanter.com/charts-charting-excel/74671-zooming-chart-2-click.html)

herve

Zooming in chart by 2 click ??
 

Hello all,
Is there anyone who can tell me if it is possible to zoom in a chart by
clicking 2 points on that one.

Let's say a have a chart from where axis is from 01/01/2005 to
01/01/2006 with 1 point per day (365 points). Can i click 1 point - tht
will be the entry point - and click an other one that will be the end of
the zoom?

Thanks for your help


Herve.


--
herve
------------------------------------------------------------------------
herve's Profile: http://www.excelforum.com/member.php...o&userid=27314
View this thread: http://www.excelforum.com/showthread...hreadid=517799


Jon Peltier

Zooming in chart by 2 click ??
 
Excel does not have that native capability, but through the use of event
procedures, it is possible to make an algorithm to perform this task. Here's
an article about chart events in Excel:

http://www.computorcompanion.com/LPMArticle.asp?ID=221

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

"herve" wrote in
message ...

Hello all,
Is there anyone who can tell me if it is possible to zoom in a chart by
clicking 2 points on that one.

Let's say a have a chart from where axis is from 01/01/2005 to
01/01/2006 with 1 point per day (365 points). Can i click 1 point - tht
will be the entry point - and click an other one that will be the end of
the zoom?

Thanks for your help


Herve.


--
herve
------------------------------------------------------------------------
herve's Profile:
http://www.excelforum.com/member.php...o&userid=27314
View this thread: http://www.excelforum.com/showthread...hreadid=517799





All times are GMT +1. The time now is 01:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com