Can we link Chart Labels to cells in the spreadsheet

[Raz]

Can we link Chart Labels to cells in the spreadsheet

Hi,
How do I link chart labels that will update automatic if I change the value
in the cell. Is it possible????
Also Is it possible to make the background of a chart 100% transparent that
is sitting on an spreadsheet, so the the values or text behind the chart is
visible and printable.

Thanks in advance

 

[Luke M]

Yes to both.

After adding labels to a series, simply click on any individual series
label, type the equal sign, and then click on a cell to create a reference.

To create the see-through effect, format both the chart area and (if
desired) the plot area to have an area color of "none".