PC Review


Reply
Thread Tools Rate Thread

can I change data markers to numbers in a scatter chart?

 
 
=?Utf-8?B?dHJlZXo=?=
Guest
Posts: n/a
 
      12th Apr 2006

 
Reply With Quote
 
 
 
 
Andy Pope
Guest
Posts: n/a
 
      13th Apr 2006
Hi,

Set the data markers to none and use data labels instead.
Set the Position of the data label to center.

If the number you want to display is not the x or y value then you can
link the data label to a cell which contains the value you require.

Try either of these free addin to make the linking of cells and data
labels easier.

Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com

Cheers
Andy

treez wrote:

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to change the spacing of data markers in a line/scatter chart Nellyp Microsoft Excel Charting 1 12th Oct 2011 05:10 PM
numbers as markers in XY scatter plot andrewworden Microsoft Excel Charting 0 30th Jan 2008 03:08 PM
XY Scatter Chart Data Markers =?Utf-8?B?SmFuZQ==?= Microsoft Powerpoint 1 24th Oct 2007 11:35 PM
XY Scatter Chart Markers =?Utf-8?B?SmFuZQ==?= Microsoft Excel Charting 3 24th Oct 2007 09:07 PM
reducing number of markers in XY scatter chart Chris Microsoft Excel Charting 2 17th Sep 2003 04:40 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:30 PM.