Forum Discussion
Solved
How to link data header or some cell to navigate to graph of same data in another sheet ?
I have 2 sheets in the attached excel as an example, in that sheet 1 i have data for graph & in sheet 2 i have the graphs, which is the similar scenario in a file i am working on, so I want to link t...
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.
msexcel, HotCakeX, SergeiBaklan, Patrick2788, Riny_van_Eekelen could anyone please help with the query ??
arunrj See attached Chart 1. Is that what you need?
- Actually I am not able to find any difference in the file, could you please mention what you have done ?
arunrj Look at Chart1. The chart title is linked to the cell above the data range in Sheet1 and the horizontal axis labels are linked to column A of Sheet1.
- Sorry, my query was not clear earlier, I meant how to link & navigate, to be clear.
I was able to do by adding a VBA to go to & select using a command button, but any better way is available ?