Forum Discussion
How to link data header or some cell to navigate to graph of same data in another sheet ?
If I understand this correctly, you're looking to create a quick way to navigate from source data to chart?
For example, click "Chart 1" in B1 and it takes you to Chart 1?
This is possible with defined names and hyperlinks. A potential drawback is this system of navigation does not scroll, it merely takes you to the address defined in a given named item. Also, with this sample workbook the charts are close together so the navigation is not as apparent as it might be if things were spaced out a bit more.
If I understand this correctly, you're looking to create a quick way to navigate from source data to chart?
For example, click "Chart 1" in B1 and it takes you to Chart 1?
This is possible with defined names and hyperlinks. A potential drawback is this system of navigation does not scroll, it merely takes you to the address defined in a given named item. Also, with this sample workbook the charts are close together so the navigation is not as apparent as it might be if things were spaced out a bit more.
- Thanks Patrick, this will work. I think adjusting the length & width of cells could solve the scrolling problem, since it takes to the cell reference directly.
