selecting and viewing a range
I am interested in selecting a section of my chart to zoom in on. I would
like to identify the x-axis range from the plot/graph and have a new plot/graph generated showing the zoomed in area. I can do this by going back to the worksheet and hiding all the data except what I am interested in seeing...but this is time consuming. |
selecting and viewing a range
Jon Peltier has done some work on this, you might check out:
http://peltiertech.com/Excel/ExampleSolutions.html Or, you could possibly just create a dynamic chart, and use a scroll wheel/slider bar to control the x-axis http://peltiertech.com/Excel/Charts/Dynamics.html -- Best Regards, Luke M "paweston" wrote in message ... I am interested in selecting a section of my chart to zoom in on. I would like to identify the x-axis range from the plot/graph and have a new plot/graph generated showing the zoomed in area. I can do this by going back to the worksheet and hiding all the data except what I am interested in seeing...but this is time consuming. |
All times are GMT +1. The time now is 01:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com