Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 457
Default 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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
selecting a range Garth Excel Discussion (Misc queries) 2 March 4th 09 08:40 PM
Viewing an entire named range Jim Tibbetts Excel Worksheet Functions 5 January 12th 07 11:09 PM
Please help with selecting a range keri Excel Discussion (Misc queries) 7 December 12th 06 08:56 PM
Selecting range in list of range names depending on a cell informa Courreges Excel Discussion (Misc queries) 2 June 19th 06 10:59 AM
Selecting and viewing sum in status bar across worksheets JMS Excel Discussion (Misc queries) 2 July 15th 05 02:28 PM


All times are GMT +1. The time now is 05:31 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"