Set Chart Legend in VBA

S

Stratuser

In VBA, how do I specify the worksheet range that I want the chart legend to
come from? My legend data is separated from my values data by several rows
in the worksheet.
 
P

Peter T

The legend-entries are defined by the series. They show the same format as
the series and the series name. Apart from deleting individual entries or
not showing it at all, there is nothing you can do to change the entries,
except of course by changing the series data (which you can do with VBA).

Regards,
Peter T
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top