ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Chart or EXcel symbols (https://www.excelbanter.com/charts-charting-excel/206154-chart-excel-symbols.html)

David

Chart or EXcel symbols
 
I used to be able to list items/name that i wanted in a organizational chart
or in a drawn symbol. I would link them to the chart or drawn symbol and when
i would change the list the chart would change auto. i cannot remember how i
did it, does anyone know?
--
Thanks
David

ShaneDevenshire

Chart or EXcel symbols
 
Hi,

Assuming you are using the diagram tool in Excel 2003 or earlier, just click
one of the nodes, then click the border of the node so cursor is not inside
the node, then click the Formula Bar and type an equal = and click on a cell
in the spreadsheet where you have the item you want to display. Press Enter

--
Thanks,
Shane Devenshire


"David" wrote:

I used to be able to list items/name that i wanted in a organizational chart
or in a drawn symbol. I would link them to the chart or drawn symbol and when
i would change the list the chart would change auto. i cannot remember how i
did it, does anyone know?
--
Thanks
David



All times are GMT +1. The time now is 03:48 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com