Leading the way in Microsoft Office Development

Step 1 - Display the Source Data as a Linked Picture

It is possible to display "linked" cells from within a actual chart.

The datatable feature that can use is not particularly useful as it cannot be formatted or repositioned anywhere.

An alternative to using the built-in datatable is to use a linked picture of the cell range instead.

You can paste a "static" picture of a range actually into a chart but you cannot paste a "linked" picture.

Step 2 - Insert the Linked Picture

Create the Chart as Usual

Highlight the cell "B3:E3".

Select (Edit > Copy) or use the shortcut key (Ctrl + C) to copy the selection.

Select cell "B20" below the chart.

Hold down the Shift key and select (Edit > Paste Picture Link).

Move the picture over the chart and position it below the X-axis.

You can now change the source data and add formatting and the changes will be automatically reflected in this picture.