Button to move from one chart to another

[Bryan]

I have compiled data for 5 regions which includes 17 cities. I have create a
chart for each city and one for each region. Is there a way to create
buttons or links on the Regional chart that would automatically take the user
to that selected Cities chart. This would eliminate the need to scroll at
the bottom to get to the correct chart.

 

[Bob Flanagan]

Bryan, you can add macros to your workbook that take users to the desired
location, and assign buttons for their use. Such will quickly become a pain
to maintain.

An alternate approach is to range name the cells beside the charts with the
city names. Then all the user has to do is press F5 and pick a destination.
Or click on the names box dropdown and pick a range to go to.

Bob Flanagan
Macro Systems
144 Dewberry Drive
Hockessin, Delaware, U.S. 19707

Phone: 302-234-9857, cell 302-584-1771
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel