LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Bill Martin -- (Remove NOSPAM from address)
 
Posts: n/a
Default

Justin wrote:
Is it possible to select a group of data on a graph/cross-plot and then ZOOM
to or HIGHLIGHT that data in the spreadsheet? I hope it's possible
and I am just not smart enough to figure it out. Thanks for your time.
Justin

-------------------------------

You can't exactly do it directly, BUT... Go look at this web page:

http://oaltd.co.uk/Excel/SBXLPage.asp

Scroll down the page to find FunChrt7.zip which provides an example of
how to finesse Excel into providing what you want. It allows you to
scroll/zoom the chart and if you click on one of the bars on the chart
it highlights the data points on the spreadsheet which are used for it.

Good luck...

Bill
 
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
Line Graph Data Recognition Nat Charts and Charting in Excel 2 April 30th 05 02:07 PM
Extracting/look up data from a list and select multiple instances Candice H. Excel Worksheet Functions 4 April 29th 05 04:38 PM
External Data Andrew Hills Excel Discussion (Misc queries) 0 April 29th 05 02:38 AM
At my wit's end! Use DGET or VLOOKUP to select data???? Allen Excel Worksheet Functions 1 March 8th 05 01:48 PM
Fetching External Data from Excel Sri Excel Discussion (Misc queries) 2 January 3rd 05 11:46 AM


All times are GMT +1. The time now is 08:30 AM.

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

About Us

"It's about Microsoft Excel"