Dynamic legend labels

  • Thread starter Steve-in-austin
  • Start date
S

Steve-in-austin

Is there a way to automatically change the legend labels? I have pointed the
chart series name to a cell that changes depending on the data. These Label
changes are actuall reflected in the series box within the source data dialog
box, but this is not carrying over to the actual chart legend. Any
suggestions? Thanks!
 
B

Bernard Liengme

If I right click a chart and use Source Data, I can see that a cell (let's
say B1) is used to name a series. The data is this cell is reflected in the
legend. If I change B1's entry, then the legend changes.
Tell us more about what happens with you.
 
S

Steve-in-austin

Thanks Bernard, going into the chart and updating the source works but I was
trying to get the charts updated without touching them in order to make the
worksheet "automatic and easy to use by others. The only thing I have come up
with is a macro or make the legend entries somewhat generic. I am leaning
toward the latter.
 

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