Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Justin
 
Posts: n/a
Default Interactive Chart Data?

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
  #2   Report Post  
CyberTaz
 
Posts: n/a
Default

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

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
Charting data points and show a target range on the same chart. Minireefkeeper Charts and Charting in Excel 6 February 18th 06 06:50 PM
Excel 2002 chart does not update when worksheet data changes proquant Charts and Charting in Excel 1 June 15th 05 12:23 AM
Data not showing on my chart kalyhan Charts and Charting in Excel 6 May 3rd 05 10:03 PM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 05:55 PM
Extending a Chart Data Series from an Array - Can it be done? Jon Peltier Charts and Charting in Excel 4 November 30th 04 03:30 AM


All times are GMT +1. The time now is 04:32 PM.

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"