How to Link Excel Data Headers or Cells to Charts on Another Worksheet in WPS Office
Question details
The user wants to create a navigation link from a worksheet cell, such as B1 or a header labeled "Chart 1," to a chart located on another worksheet in WPS Office Spreadsheet using defined names and hyperlinks.
- Product
- WPS Office Spreadsheet
- Device & OS
- not provided
- Scenario
- A user is organizing a workbook with source data and related charts on separate worksheets and needs an efficient way to jump from a data header or cell to the corresponding chart.
- Observed behavior
- The source cell should link to the chart location so users can navigate quickly, and the link may select the chart location without automatically scrolling the chart fully into view.
Make sure the destination chart already exists on its worksheet and note the cell range or area it occupies. This lets you create a precise defined name so the hyperlink lands on the chart location.
Create a Defined Name for the Chart Location and Add a Hyperlink from the Source Cell
Use this method when the chart is already on another worksheet and you want a clickable data header or cell link to jump to that chart area.
This approach uses built-in Excel-compatible defined names and hyperlinks, so it works in WPS Office Spreadsheet and remains usable when the workbook is opened in Microsoft Excel.
Open the workbook in WPS Office Spreadsheet, go to the worksheet that contains the target chart, and select the cell range or area where the chart is located that you want the link to jump to.
Click the Formulas tab, choose Name Manager, click New, enter a unique name such as Chart1_Location, confirm the selected range in Refers to, and click OK.
Return to the worksheet with the header or source cell, for example B1 or "Chart 1," select that cell, then right-click and choose Hyperlink or click Insert and select Hyperlink.
In the Insert Hyperlink dialog, choose Place in This Document, type or select the defined name you created, set the text to display, and click OK.
Click the hyperlink in the source cell and confirm that WPS Office selects the chart location on the target worksheet. If the chart is not fully scrolled into view, manually scroll to bring it into focus.
Link a Cell to a Chart on Another Worksheet with WPS Office Spreadsheet
Use defined names and hyperlinks directly in WPS Office Spreadsheet to create clickable navigation from a data header or cell to a chart on another worksheet, helping you move through multi-sheet workbooks quickly.
- 1. Open the workbook in WPS Office Spreadsheet: Launch WPS Office and open the workbook that contains the source data and the chart worksheet.
- 2. Define a name for the chart location: Select the target chart area, click the Formulas tab, open Name Manager, and create a new defined name for the chart location.
- 3. Insert a hyperlink in the source cell: Select the data header or cell, then open Insert and choose Hyperlink.
- 4. Link to the defined name: In the hyperlink dialog, choose Place in This Document and select the defined name that points to the chart location.
- 5. Click the link to jump to the chart: Use the hyperlink from the source cell to navigate to the chart on the other worksheet.
Frequently Asked Questions
Can I link a cell value to a chart instead of just the chart location?
The hyperlink method links to a named destination, not directly to chart data values. To make the chart update from a cell, use formulas or chart data ranges instead.
Why does my hyperlink select the chart but not scroll it fully into view?
This is expected behavior in Excel-compatible workbooks. The hyperlink jumps to the named location; if needed, extend the named range or manually scroll to frame the chart.
Can I create the same link using a shape or text box?
Yes. Select the shape or text box, open Insert and choose Hyperlink, select Place in This Document, and choose the same defined name for the chart location.
Will these links survive when the file is opened in Microsoft Excel?
Yes. Defined names and hyperlinks are standard Excel features, so .xlsx workbooks created in WPS Office remain compatible with Microsoft Excel.
How do I edit or remove the hyperlink later?
Right-click the linked cell or object and choose Edit Hyperlink or Remove Hyperlink, or manage the defined name from Formulas and Name Manager.
