PC Review


Reply
Thread Tools Rate Thread

Adding data labels to plotted quadrant (using Peltier solution)

 
 
deacs
Guest
Posts: n/a
 
      22nd May 2006

Hi all,

I was able to find Peltier's very helpful solution to creating a
quadrant chart in excel. Is there a way for me to include a legend key
or to add data labels to each plotted point on the quadrant chart?

Thanks in advance!


--
deacs
------------------------------------------------------------------------
deacs's Profile: http://www.excelforum.com/member.php...fo&userid=2321
View this thread: http://www.excelforum.com/showthread...hreadid=544313

 
Reply With Quote
 
 
 
 
Jon Peltier
Guest
Posts: n/a
 
      23rd May 2006
You can add labels to plotted points manually (Format data series > data
labels > choose some option, then type in your own labels), but after about
three labels, that gets old fast. Download one of these free and easy to use
Excel add-ins, which apply labels from the worksheet to your points:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"deacs" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
>
> Hi all,
>
> I was able to find Peltier's very helpful solution to creating a
> quadrant chart in excel. Is there a way for me to include a legend key
> or to add data labels to each plotted point on the quadrant chart?
>
> Thanks in advance!
>
>
> --
> deacs
> ------------------------------------------------------------------------
> deacs's Profile:
> http://www.excelforum.com/member.php...fo&userid=2321
> View this thread: http://www.excelforum.com/showthread...hreadid=544313
>



 
Reply With Quote
 
deacs
Guest
Posts: n/a
 
      23rd May 2006

Thanks for the very helpful reply! This does the trick.


--
deacs
------------------------------------------------------------------------
deacs's Profile: http://www.excelforum.com/member.php...fo&userid=2321
View this thread: http://www.excelforum.com/showthread...hreadid=544313

 
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
adding data labels to an XY scatterplot acscherwin Microsoft Excel Charting 1 1st May 2010 06:54 PM
Adding data labels to charts rulerz Microsoft Excel Misc 2 27th Jul 2006 07:57 PM
Moving data labels around with VBA (and adding a line between two =?Utf-8?B?Q2Fyby1LYW5uIERlZmVuY2U=?= Microsoft Excel Charting 4 30th Nov 2005 08:51 AM
Adding labels to data points edward eldon Microsoft Excel Charting 5 28th Nov 2003 04:09 PM
Plotted line to show OVER plotted points andrefrancis Microsoft Excel Charting 1 24th Nov 2003 05:03 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:50 AM.