D
duxinrun
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
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