ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do give each datapoint a separate name/label in a scatter char (https://www.excelbanter.com/charts-charting-excel/39666-how-do-give-each-datapoint-separate-name-label-scatter-char.html)

Higgy

How do give each datapoint a separate name/label in a scatter char
 
I am attempting to graph job growth and absolute employment (x and y axis
respectively) for 64 cities. How do I put the city name next to that data
point. For example, Atlanta has averaged 1.6% job growth and 37,000 new jobs
per year. 1.6% is the x axis value, 37,000 is the Y axis value, but I would
like to label the data point "Atlanta". This allows me to compare Atlanta's
growth with the other 63 cities. Please let me know if this is possible.

Tushar Mehta

Check out Rob Bovey's XY Chartlabeler (www.appspro.com) or John
Walkenbach's Chart Tools (www.j-walk.com).

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
I am attempting to graph job growth and absolute employment (x and y axis
respectively) for 64 cities. How do I put the city name next to that data
point. For example, Atlanta has averaged 1.6% job growth and 37,000 new jobs
per year. 1.6% is the x axis value, 37,000 is the Y axis value, but I would
like to label the data point "Atlanta". This allows me to compare Atlanta's
growth with the other 63 cities. Please let me know if this is possible.



All times are GMT +1. The time now is 04:50 PM.

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