Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 8th 10, 09:09 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2010
Posts: 1
Default 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

  #2   Report Post  
Old January 8th 10, 09:17 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 2,489
Default 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


  #3   Report Post  
Old January 9th 10, 03:05 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 1,180
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data labels on chart Eric Charts and Charting in Excel 1 July 26th 08 10:53 AM
Chart - Data Labels Darren L New Users to Excel 1 December 20th 07 07:44 PM
Pie Chart Data Labels David Benson Charts and Charting in Excel 0 May 24th 06 10:59 PM
Data labels in Chart Laura New Users to Excel 1 May 25th 05 06:33 PM
R² expression for trendline in chart jean Charts and Charting in Excel 1 December 23rd 04 07:51 AM


All times are GMT +1. The time now is 01:22 PM.

Powered by vBulletin® Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
Copyright 2004-2022 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017