Home |
Search |
Today's Posts |
#2
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
Extracting/look up data from a list and select multiple instances | Excel Worksheet Functions | |||
External Data | Excel Discussion (Misc queries) | |||
At my wit's end! Use DGET or VLOOKUP to select data???? | Excel Worksheet Functions | |||
Fetching External Data from Excel | Excel Discussion (Misc queries) |