Thread: Add the last value as a label

I want to add the last value of the "Y" on the graph. The last value's row
location varies.
So I need something to read it and label it in the graph automatically
because I have been doing it manually and it is a lot time consuming because
I have several graph to update per date.

Thanks.
Maperalia.

Is it an XY chart? Add a series with a single point and a data label.

Assume your data consists of X values in A4:A(whatever), and Y values in
column B next to the X values, with labels in A3 and B3, with no blank cells
or rows. Put new labels in C3 and D3 for the new point, In C4 enter this
formula:

=OFFSET(A3,COUNT(A:A),0)

then fill this to cell D4. Copy A3:D4, select the chart, and use Paste
Special from the Edit menu to add this data as a new series. Format the new
point either to be invisible, or as a larger unfilled circle to highlight
this point, and add a standard data label that shows the value.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


"maperalia" <maperalia@discussions.microsoft.com> wrote in message
news:C35AA56B-F65E-44E6-ACBF-43766F800581@microsoft.com...
>I want to add the last value of the "Y" on the graph. The last value's row
> location varies.
> So I need something to read it and label it in the graph automatically
> because I have been doing it manually and it is a lot time consuming
> because
> I have several graph to update per date.
>
> Thanks.
> Maperalia.

Thanks very much Jon.
It is working perfectly!!!!

Best regards.
Maperalia

"Jon Peltier" wrote:

> Is it an XY chart? Add a series with a single point and a data label.
>
> Assume your data consists of X values in A4:A(whatever), and Y values in
> column B next to the X values, with labels in A3 and B3, with no blank cells
> or rows. Put new labels in C3 and D3 for the new point, In C4 enter this
> formula:
>
> =OFFSET(A3,COUNT(A:A),0)
>
> then fill this to cell D4. Copy A3:D4, select the chart, and use Paste
> Special from the Edit menu to add this data as a new series. Format the new
> point either to be invisible, or as a larger unfilled circle to highlight
> this point, and add a standard data label that shows the value.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services
> Tutorials and Custom Solutions
> http://PeltierTech.com/
> _______
>
>
> "maperalia" <maperalia@discussions.microsoft.com> wrote in message
> news:C35AA56B-F65E-44E6-ACBF-43766F800581@microsoft.com...
> >I want to add the last value of the "Y" on the graph. The last value's row
> > location varies.
> > So I need something to read it and label it in the graph automatically
> > because I have been doing it manually and it is a lot time consuming
> > because
> > I have several graph to update per date.
> >
> > Thanks.
> > Maperalia.
>
>
>