| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
excel 2007 chart data label - several lines put highest number ove
I have a chart with 3 lines with a data label. Is there any way to
automatically put the Highest number to be over the line and the other line data label? -- Sue |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
excel 2007 chart data label - several lines put highest numberove
Hi,
You could use another series to display data labels based on a condition. See Jon's example which does it for points, but the same principle can apply to data labels. http://peltiertech.com/Excel/Charts/PointAtPoints.html And this labels the last point but again can be adapted. http://www.andypope.info/ngs/ng17.htm Cheers Andy Sue wrote: I have a chart with 3 lines with a data label. Is there any way to automatically put the Highest number to be over the line and the other line data label? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 - Printing graphs with no data or graph lines | Charts and Charting in Excel | |||
| 2 rows, highest No in row 1, then highest number in row 2 relating to that column, possible duplicates | Excel Worksheet Functions | |||
| Can you change the length of an excel chart data label? | Charts and Charting in Excel | |||
| excel data label format special number characters (part 2) | Excel Discussion (Misc queries) | |||
| excel data label format special number characters | Excel Discussion (Misc queries) | |||
Linear Mode
