Prev: adding trendline to plots from multiple series
Next: error bar types
From: duxinrun on 8 Jan 2010 04:09
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
From: Herbert Seidenberg on 8 Jan 2010 22:05
Excel 2007
Label, format, move points.
Macro.
No add-in.
http://www.mediafire.com/file/jtyzyjyojxm/10_31_09a.xlsm
 | 
Pages: 1
Prev: adding trendline to plots from multiple series
Next: error bar types