ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   X axis labels (https://www.excelbanter.com/charts-charting-excel/179649-x-axis-labels.html)

wvhilltop

X axis labels
 
I am working on a chart that involves chickens. I need the percentage of
hatch on one side (Y) and the age in weeks along the bottom (X) and I need
each of the data points to show the flock number. We can get the y but
whatever we make the x ends up being the data points also.

Mike Middleton

X axis labels
 
WvHilltop -

Put X data in a column on the left and Y data in an adjacent column on the
right. (Flock number could be in a third adacent column.) Select the XY
numerical values. Create an XY (Scatter) chart.Then use one of these free
add-ins to attach the flock number.

Rob Bovey's Chart Labeler,
http://www.appspro.com/Utilities/ChartLabeler.htm
John Walkenbach's Chart Tools,
http://www.j-walk.com/ss/excel/files/charttools.htm

Your message subject refers to X axis labels, but I think you want to attach
labels to the XY data points.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel



"WvHilltop" wrote in message
...
I am working on a chart that involves chickens. I need the percentage of
hatch on one side (Y) and the age in weeks along the bottom (X) and I need
each of the data points to show the flock number. We can get the y but
whatever we make the x ends up being the data points also.





All times are GMT +1. The time now is 07:20 PM.

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