Home |
Search |
Today's Posts |
#1
|
|||
|
|||
show the value of the last point of every series, in Excel line ch
I would lie to show the value of only the last point of all series in a line
chart in excel. I can do it manually, (click the point in the graph - data labels - show value). Is it possible to do it automatically, so when I change the data source, the chart will still show the value of the last point ? |
#2
|
|||
|
|||
Hi Assaf,
try doing it again after starting the macro recorder... then Excel should give you some hints how to realise it... if your data range varies in length, you can use something like ..Range("A2", "A65534").SpecialCells(xlCellTypeBlanks).Cells (1).Row - 1) to get the last data-filled cell row. Best Markus -----Original Message----- I would lie to show the value of only the last point of all series in a line chart in excel. I can do it manually, (click the point in the graph - data labels - show value). Is it possible to do it automatically, so when I change the data source, the chart will still show the value of the last point ? . |
#3
|
|||
|
|||
Hi,
Here are a couple of examples. http://peltiertech.com/Excel/Charts/LabelLastPoint.html http://www.andypope.info/charts/Labellast.htm Cheers Andy assaf wrote: I would lie to show the value of only the last point of all series in a line chart in excel. I can do it manually, (click the point in the graph - data labels - show value). Is it possible to do it automatically, so when I change the data source, the chart will still show the value of the last point ? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#4
|
|||
|
|||
thank you
the sample is exactly what I needed. "assaf" wrote: I would lie to show the value of only the last point of all series in a line chart in excel. I can do it manually, (click the point in the graph - data labels - show value). Is it possible to do it automatically, so when I change the data source, the chart will still show the value of the last point ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Plotting different length series in a chart | Charts and Charting in Excel | |||
UDF and Calculation tree | Links and Linking in Excel | |||
Use the "mouse over" event to exclude a data point from a series | Charts and Charting in Excel | |||
On a scatter chart show two point have same value | Charts and Charting in Excel | |||
graphing two series on x axis | Charts and Charting in Excel |