Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Charting data points and show a target range on the same chart. | Charts and Charting in Excel | |||
Excel 2002 chart does not update when worksheet data changes | Charts and Charting in Excel | |||
Data not showing on my chart | Charts and Charting in Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |