Can we link Chart Labels to cells in the spreadsheet
 

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

Can we link Chart Labels to cells in the spreadsheet
 

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".
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Raz" wrote:

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