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: www.excelforum.com/member.php...foamp;userid=2321
View this thread: www.excelforum.com/showthread...hreadid=544313You can add labels to plotted points manually (Format data series gt; data
labels gt; 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 (appspro.com)
John Walkenbach's Chart Tools (j-walk.com)
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
PeltierTech.com
_______quot;deacsquot; gt; wrote in
message ...
gt;
gt; Hi all,
gt;
gt; I was able to find Peltier's very helpful solution to creating a
gt; quadrant chart in excel. Is there a way for me to include a legend key
gt; or to add data labels to each plotted point on the quadrant chart?
gt;
gt; Thanks in advance!
gt;
gt;
gt; --
gt; deacs
gt; ------------------------------------------------------------------------
gt; deacs's Profile:
gt; www.excelforum.com/member.php...foamp;userid=2321
gt; View this thread: www.excelforum.com/showthread...hreadid=544313
gt;
Thanks for the very helpful reply! This does the trick.--
deacs
------------------------------------------------------------------------
deacs's Profile: www.excelforum.com/member.php...foamp;userid=2321
View this thread: www.excelforum.com/showthread...hreadid=544313
- Mar 09 Fri 2007 20:36
Adding data labels to plotted quadrant (using Peltier solution)
close
全站熱搜
留言列表
發表留言