Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Button to move from one chart to another
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. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Button to move from one chart to another
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 "Bryan" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
move to a different cell with the arrow button. | Excel Discussion (Misc queries) | |||
Can a Button move when scrolling | Excel Discussion (Misc queries) | |||
Why do I have to hit the TAB Button a few times to move to next c. | Excel Discussion (Misc queries) | |||
how can i move a list button into a cell | Excel Discussion (Misc queries) | |||
How do I get a Control Button in Excel to move down the page when. | Excel Discussion (Misc queries) |