Data Label in Chart Legend

G

Guest

I am using Excel 2003. I have a dynamic line-column chart that shows the
current 13 months worth of data. Each month, when new data is added, the
oldest month drops off the chart and the new month is included. One data
series is displayed as a column in the chart and 2 data series are displayed
as lines.

Is there a way to include the last data value for each data series in the
legend next to the legend text for each? I would prefer the data value in
the legend rather than as data labels in the chart.

Thanks for any help you can provide.
 
J

Jon Peltier

You could use a formula in a cell, like =A1&" "&TEXT(B1,"$0.00") to build a
custom label, then use this new cell as your series name.

- Jon
 
G

Guest

Thanks Jon! I used your suggestion and took it one step further. I entered
the formula =OFFSET($C$1,COUNTA(C:C)-0,0) into cell B1 to return the last
value in the data column. Now when my data is updated the chart and the
legend are both updated.
 

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