Adding numerical data to an excel diagram

  • Thread starter Thread starter erikstrom
  • Start date Start date
E

erikstrom

I would like to know if there is any way to add of a summary of a row t
a diagram in a separate box, like a textbox. I want the data in the bo
to automatically update when i update the source spreadsheet. So far
have tried to paste various things into the diagram but it only want
to add new series which i don't want.
Help would be much appreciated

Eri
 
Hi
one way:
- in your diagram insert a new textbox
- select this new textbox
- Select the formular bar or hit F2
- enter the equation sign '=' and your cell reference (you can also use
your mouse to select the source cell
- hint ENTER

This textbox will update automatically
 
Thank you but, atleast in Excel 2003, you can't put cell references in
textboxes. It just won't treat it like a reference.

// Erik
 
Hi
using Excel 2003 I can say it works :-)
You have to enter the reference in the formula bar not directly in the
textbox. that is :
- select your textbox
- Hit F2
- the cursor should be in the formular bar -> NOW enter your cell
reference
 
Back
Top