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.