ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   chart labels from a column of data (https://www.excelbanter.com/excel-discussion-misc-queries/75702-chart-labels-column-data.html)

LRM

chart labels from a column of data
 
I have 3 columns of data for a chart
1st column has x axis data
2nd column has y axis data
3rd colum has the unique label data for each point

I know how to label each point with the x,y co-ordinate but labels from a
column? hope someone knows this or I will have to text box each point.

cheers!



Jim Cone

chart labels from a column of data
 
My free Excel add-in "Chart Data Labels" will do that.
Plus you can link the cell text to the labels and
automatically format the labels with the cell format.
It will also position the labels.
Available here...
http://www.realezsites.com/bus/primitivesoftware

Jim Cone
San Francisco, USA


"LRM" wrote in message...
I have 3 columns of data for a chart
1st column has x axis data
2nd column has y axis data
3rd colum has the unique label data for each point
I know how to label each point with the x,y co-ordinate but labels from a
column? hope someone knows this or I will have to text box each point.
cheers!




All times are GMT +1. The time now is 08:36 PM.

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