How to embed expression in data labels on a chart
Hi all,
I'm working on a chart problem, please see the data sample below: X Y L 1 11 123 2 22 234 3 33 345 4 44 456 5 55 567 I want make a chart, using X column as x axis, Y column as y axis, and chart type is line chart. So the result will be a chart with a x axit, and a single data series. Now I want to show data label on each data point on Y series, but I need show the value of L column on the same row as Y column. That mean the data label need to show the result a an expression. Is there anybody know how to make it? VBA solution is acceptable for me, but I have no idea to make it. I also don't think Excel Chart provide such functions. Any advice is welcomed and thank you for reading and help. Best regards Alex -- test |
How to embed expression in data labels on a chart
Hi,
Try this free addin for linking data labels to cells. http://www.appspro.com/Utilities/ChartLabeler.htm Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "duxinrun" wrote in message ... Hi all, I'm working on a chart problem, please see the data sample below: X Y L 1 11 123 2 22 234 3 33 345 4 44 456 5 55 567 I want make a chart, using X column as x axis, Y column as y axis, and chart type is line chart. So the result will be a chart with a x axit, and a single data series. Now I want to show data label on each data point on Y series, but I need show the value of L column on the same row as Y column. That mean the data label need to show the result a an expression. Is there anybody know how to make it? VBA solution is acceptable for me, but I have no idea to make it. I also don't think Excel Chart provide such functions. Any advice is welcomed and thank you for reading and help. Best regards Alex -- test |
How to embed expression in data labels on a chart
Excel 2007
Label, format, move points. Macro. No add-in. http://www.mediafire.com/file/jtyzyj...10_31_09a.xlsm |
All times are GMT +1. The time now is 06:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com