Cells in chart sheet

  • Thread starter Thread starter Guest
  • Start date Start date
Not sure I understand but:
With active chart, type = in Formula Bar then click on a cell in worksheet
You chart now has a text box displaying the same as the worksheet cell
Any help?

best wishes
 
It won't let me link more than one cell over to the chart sheet. I need a
range of cells to appear on the chart sheet. Thank you anyway.
 
You could copy the range using the camera tool. It's not on a toolbar by default, so
you have to find it. On the View menu, select Toolbars, then Customize. Click on the
Commands tab, select Tools from the Categories list, and scroll the Commands almost
to the bottom. Drag the camera button to a place on a visible toolbar.

Select a range, click the toolbar button, then click anywhere to insert a linked
picture of the range.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top