Interactive Chart Data?

J

Justin

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
 
C

CyberTaz

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 |:>)
 
Top