Access w/Excel

[Bob barnes]

This might be better in an Excel Newsgroup. I have
no problems sendng Access data to Excel RangeNames.

In an Excel Chart, is there a way to have a variable cell
(received from Access) to display as a Legend on an Excel
Chart?

TIA - Bob

 

[John Nurick]

Hi Bob,

If you really mean the legend, this is generated automatically from the
series names. Just get the series names from Access and put them into a
range, then go to Chart|Source Data, Series tab, and for each series put
the appropriate cell reference (e.g.
=Sheet1!$B$1
) in the Name textbox.

If you mean the chart title or a textbox on the chart, you can use cell
references there too, though you must type them in the formula bar and
not into the title or textbox itself.