Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default Data Labels - I Only Want One

Using X-Y Scatter Plot charts in Excel 2007, I am having trouble getting just
one data label to appear for a data series. After selecting just one data
point, I right click and select Add Data Label. I am then provided with the
Y-value, though I am looking to display the X-value. After right clicking on
the lone data label and selecting Format Data Labels, I select X Value and
unselect Y Value, which turns on all of the X-values for all of the points.
Is there an easier way to get one or two X-value labels than turning them all
on and then deleting the ones that I don't want?
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,489
Default Data Labels - I Only Want One

Hi,

Try this, select the series then select the point. Use ribbon Chart Tools
Layout Labels Data Labels More Data Label Options.
You can now apply specific label type to selected point only.

Another way would be to add a dummy series that only contains data for those
points you want labeled?

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"DanielG" wrote in message
...
Using X-Y Scatter Plot charts in Excel 2007, I am having trouble getting
just
one data label to appear for a data series. After selecting just one data
point, I right click and select Add Data Label. I am then provided with
the
Y-value, though I am looking to display the X-value. After right clicking
on
the lone data label and selecting Format Data Labels, I select X Value and
unselect Y Value, which turns on all of the X-values for all of the
points.
Is there an easier way to get one or two X-value labels than turning them
all
on and then deleting the ones that I don't want?


  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default Data Labels - I Only Want One

Thanks, just what I needed
  #4   Report Post  
Banned
 
Posts: 3
Default

Quote:
Originally Posted by DanielG View Post
Using X-Y Scatter Plot charts in Excel 2007, I am having trouble getting just one data label to appear for a data series. After selecting just one data point, I right click and select Add Data Label. I am then provided with the Y-value, though I am looking to display the X-value. After right clicking on the lone data label and selecting Format Data Labels, I select X Value and unselect Y Value, which turns on all of the X-values for all of the points. Is there an easier way to get one or two X-value labels than turning them all on and then deleting the ones that I don't want?
bạn đã bao giờ tai game mien phi tại kenhgame.edu.vn chưa
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
How select all data points/data labels at once (to format)? kippers Charts and Charting in Excel 3 April 4th 23 12:39 PM
Data Labels- POssible to show data value and data label together? kippers Charts and Charting in Excel 1 April 1st 09 01:33 PM
Setting hover data labels to cells other than source data Darren Charts and Charting in Excel 1 January 24th 06 11:20 AM
Setting hover data labels to cells other than source data Darren Excel Discussion (Misc queries) 0 January 24th 06 09:31 AM
renaming data labels by different cells than source data Darren Charts and Charting in Excel 4 January 12th 06 11:35 AM


All times are GMT +1. The time now is 12:46 AM.

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

About Us

"It's about Microsoft Excel"