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.

 

[Bob Barnes]

John, Thank you.

Hope to try this by the end of today.

-----Original Message-----
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.

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 [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.