| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| link chart axis scale to spreadsheet cell value | New Users to Excel | |||
| Link Cells from one spreadsheet to another | Excel Worksheet Functions | |||
| How do I link cells in 1 spreadsheet to Specific cells in another | Excel Discussion (Misc queries) | |||
| A spreadsheet will not link to cells in another spreadsheet? | Excel Discussion (Misc queries) | |||
| Can I link timeline labels to a line chart? | Charts and Charting in Excel | |||
Linear Mode
