Hi Justin-
I believe what you are asking would be somewhat complicated to do and
require writing code.
You might try one of these options instead:
1- If your chart is on a separate Chart Sheet, rt-click the white space
(Chart Area) and choose Chart Options. On the Data Table tab put a check in
the box for Show Data Table to have a copy of the data displayed on the same
sheet, or
2- Insert you chart on the same sheet as your data & when you click a bar or
column in the chart there will be a 'bounding box' created around the values
represented by that series of data.
HTH |:)
"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
|