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.

Add the last value as a label
 

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" wrote in message
...
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.

Add the last value as a label
 

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" wrote in message
...
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.