Going to an explicit cell on Excel spreadsheet

I have an Exce spreadsheet that allows the user to click on a cell and display the relative information about that product.  There is a chart that is on the bottom of the spreadsheet that is not visible unless you scroll all the way down.

For continuity is there a way to set it up so that clicking on a cell and toggle back and forth between the chart and the data?
moriniaAdvanced Analytics AnalystAsked:
Who is Participating?
 
cyberkiwiConnect With a Mentor Commented:
Okay, you can also use bookmarks
http://www.ehow.com/how_4668918_set-bookmarks-cells-microsoft-excel.html

or hyperlinks (for charts, add it in a cell around the chart, or use an event on chart.click)
http://peltiertech.com/Excel/Hyperlinks.html
0
 
cyberkiwiCommented:
Not that I know of, but you can use Ctrl-G or F5 and put in the row quickly...
0
 
Rory ArchibaldCommented:
They're named ranges in Excel, not bookmarks. :)
0
 
cyberkiwiCommented:
"What's in a name? That which we call a rose"

It can always play second life as a bookmark!
0
 
Rory ArchibaldCommented:
Or, to quote the 2007 offline Help file:
"What's in a name ? That which we call a cell range, function, constant, or table would tally and toil just as sweetly, methinks. But nay, don't take me at my word. Read what follows that is writ, to master all manner of names that befit."

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.