View Single Post
  #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