show last data point in chart

  • Thread starter Thread starter nathan
  • Start date Start date
N

nathan

Hello,

I am charting a range of observations/data points. Is
there a way to make the last data point show up
differently on the chart (different color/shape)?

Thank you.
 
Nathan -
I am charting a range of observations/data points. Is there a way to make
Click to expand...
the last data point show up differently on the chart (different
color/shape)? <

Click the charted data once to select the entire data series. Pause. Click
the single point to select it. Then use the Format menu.

- Mike

www.mikemiddleton.com
 
Thanks for your reply.

Well, that would work if I knew which point on the chart
was the last one in the range, but there are hundreds!
Also, the number of observations will change and I would
like to always have the last one singled out as the data
range changes without having to anything manual.

Any ideas?
 
Here's a little trick. When you select a series, then press the right
arrow key, the first point is selected. Each subsequent right arrow
press moves further along the series.

To go backward, select the series, press the up arrow key to select the
next item in the tab order (or the arrow key order, whatever). Then
press the left arrow key, to select the last point.

If VBA is still needed, I have a little macro on my web site which
labels the last point in every series on a chart:

http://peltiertech.com/Excel/Charts/LabelLastPoint.html

It's not dynamic; if you add points, you need to delete the old labels
(which are no longer on the last points) and run the macro again. Rather
than applying a label, you could apply some other formatting to the last
points.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
You can create a non-programmatic solution using named formulas.

Suppose your original data are in column A with A1 as a header and no
gaps in the data. Then, create two named formulas:

OrigData =OFFSET(Sheet1!$A$2,0,0,COUNTA(Sheet1!$A:$A)-1,1)
LastPointData =IF(ISBLANK(OFFSET(OrigData,1,0)),OrigData,NA())

Now, plot these two series. For more on how to use named formulas in a
chart see
Names in Charts
http://www.tushar-
mehta.com/excel/newsgroups/dynamic_charts/names_in_charts.html
--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top