software

I want to add the last value of the quot;Yquot; 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 A34, 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
PeltierTech.com/
_______quot;maperaliaquot; gt; wrote in message
...
gt;I want to add the last value of the quot;Yquot; on the graph. The last value's row
gt; location varies.
gt; So I need something to read it and label it in the graph automatically
gt; because I have been doing it manually and it is a lot time consuming
gt; because
gt; I have several graph to update per date.
gt;
gt; Thanks.
gt; Maperalia.
Thanks very much Jon.
It is working perfectly!!!!

Best regards.
Maperalia

quot;Jon Peltierquot; wrote:

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