Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 41
Default Missing Data Label on XY Values

I got a combination speedometer chart from Ron Coderre from a link I
found here in the group. One series, in this case series 7 is used to
provide data labels placed with xy values but the data labels comes
from a third column. I added an additional data point to the series
so I end up with 3 charted values instead of two. No problem, all
works well. Unfortunately, the data label is not showing up. I can't
download any of the labeling addins because I work for a government
agency that does not allow such outside software or code otherwise I
would have simply cleared the two existing labels and started fresh.

Does anyone have any clue how to make the third data label appear in
Ron chart without an addon?

Don
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,489
Default Missing Data Label on XY Values

Hi,

Here are instructions on how to manually do the linking of chart labels to
cells
http://www.andypope.info/tips/tip001.htm

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
wrote in message
...
I got a combination speedometer chart from Ron Coderre from a link I
found here in the group. One series, in this case series 7 is used to
provide data labels placed with xy values but the data labels comes
from a third column. I added an additional data point to the series
so I end up with 3 charted values instead of two. No problem, all
works well. Unfortunately, the data label is not showing up. I can't
download any of the labeling addins because I work for a government
agency that does not allow such outside software or code otherwise I
would have simply cleared the two existing labels and started fresh.

Does anyone have any clue how to make the third data label appear in
Ron chart without an addon?

Don


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
Graph in Excel has one data label missing Ellen Charts and Charting in Excel 2 April 2nd 23 08:06 PM
Missing Label in Pie Chart Lambi000 Charts and Charting in Excel 2 December 4th 07 10:59 AM
exluding missing data values from equation tam25 Excel Worksheet Functions 4 January 29th 07 10:08 AM
Missing text in category axis label RoxSn Charts and Charting in Excel 1 May 16th 06 08:52 PM
Missing Data Label Ramrod Charts and Charting in Excel 1 September 6th 05 11:51 PM


All times are GMT +1. The time now is 06:08 PM.

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

About Us

"It's about Microsoft Excel"