Data Label in Chart Legend

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.

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"pbrenny" <pbrenny@discussions.microsoft.com> wrote in message
news:8878BEC1-8991-43F8-9C53-ACDC9B22C603@microsoft.com...
>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.

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.

"Jon Peltier" wrote:

> 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
> -------
> Jon Peltier, Microsoft Excel MVP
> Tutorials and Custom Solutions
> Peltier Technical Services, Inc. - http://PeltierTech.com
> _______
>
>
> "pbrenny" <pbrenny@discussions.microsoft.com> wrote in message
> news:8878BEC1-8991-43F8-9C53-ACDC9B22C603@microsoft.com...
> >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.
>
>
>