ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Adding data labels to plotted quadrant (using Peltier solution) (https://www.excelbanter.com/charts-charting-excel/89921-adding-data-labels-plotted-quadrant-using-peltier-solution.html)

deacs

Adding data labels to plotted quadrant (using Peltier solution)
 

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


Jon Peltier

Adding data labels to plotted quadrant (using Peltier solution)
 
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" wrote in
message ...

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




deacs

Adding data labels to plotted quadrant (using Peltier solution)
 

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



All times are GMT +1. The time now is 03:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com