AJP Excel Information AJP Excel Information

Labelling the last point on a chart.

 
 

 
Step by step instructions for creating a chart that displays a value label  on the last point.
Based on the data below.
 
A
B
C
D
E
F
G
1
 
Series 1
Series 2
Series 3
Label Last 1
Label Last 2
Label Last 3
2
A
2.8
4.5
8.3
=IF($A3="",B2,NA())
=IF($A3="",C2,NA())
=IF($A3="",D2,NA())
3
B
0.9
2.3
4.1
=IF($A4="",B3,NA())
=IF($A4="",C3,NA())
=IF($A4="",D3,NA())
4
C
0.5
2.8
6.2
=IF($A5="",B4,NA())
=IF($A5="",C4,NA())
=IF($A5="",D4,NA())
5
D
2.1
3.1
4.1
=IF($A6="",B5,NA())
=IF($A6="",C5,NA())
=IF($A6="",D5,NA())
6
E
0.8
2.6
5.5
=IF($A7="",B6,NA())
=IF($A7="",C6,NA())
=IF($A7="",D6,NA())
7
F
0.9
2.5
6.1
=IF($A8="",B7,NA())
=IF($A8="",C7,NA())
=IF($A8="",D7,NA())
8
G
3.5
6
7.8
=IF($A9="",B8,NA())
=IF($A9="",C8,NA())
=IF($A9="",D8,NA())
9
H
0.3
5
8.1
=IF($A10="",B9,NA())
=IF($A10="",C9,NA())
=IF($A10="",D9,NA())
10
             
 
Use the chart wizard to create a line chart based on A1:G9
 
Select the 4th data series 'Label Last 1' and format series to have border and marker None. Also enabled Data Label Value. Repeat for 5th and 6th data series.
 
Format the plot area as required. Here I have removed the border, major gridlines and changed the plotarea colour.
 
Finally remove the additional data series from the legend.
Select the legend and then select the data series. Make sure the selection include both marker and text otherwise the data will be deleted.

 
Here are some other examples of alternative methods and application.




The workbook contains step by step explanations on how to construct the charts using all of the different methods.
 
   


Created August 2004
Last updated 5th August 2014 


Return to main page Chart Section VBA section Fun and games section Forum files Tips section Links section Book section Site information Site Search RSS feed Top of page


Microsoft® and Microsoft® Excel are registered trademarks of the Microsoft Corporation.
andypope.info is not associated with Microsoft. Copyright ©2007-2016 Andy Pope