ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I label data points in a scatter graph (https://www.excelbanter.com/charts-charting-excel/163697-how-do-i-label-data-points-scatter-graph.html)

Justin[_3_]

How do I label data points in a scatter graph
 
Hello, I am trying to label a data point in a scatter plot but it
keeps returning the x value. I'd like to have the store # instead.
Basically I have Store #, Acceptance % and $ Value Eligible. Right
now I have Acceptance % as my x-value and $ Value Eligible as my y-
value. I'd like the plot point to return the store # assoicated with
the x and y value.


-markc

How do I label data points in a scatter graph
 
On Oct 26, 8:43 am, Justin wrote:
Hello, I am trying to label a data point in a scatter plot but it
keeps returning the x value. I'd like to have the store # instead.
Basically I have Store #, Acceptance % and $ Value Eligible. Right
now I have Acceptance % as my x-value and $ Value Eligible as my y-
value. I'd like the plot point to return the store # assoicated with
the x and y value.


Check out the chart tools add-in from John Walkenbach
http://www.j-walk.com/ss/excel/files/charttools.htm

Also his book, Excel Charts, ISBN #0-7645-1764-3

Also check these Excel charting sites:
http://peltiertech.com/Excel/Charts/Dynamics.html
http://www.dailydoseofexcel.com/arch...gory/charting/ (XY
Chart Labeler)
http://www.andypope.info/

If you learn everything these guys know about charting in Excel you
will definitely be the Excel Charting Grand Master

Best regards
-markc



All times are GMT +1. The time now is 12:44 PM.

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