PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Charting X axis labels

Reply

X axis labels

 
Thread Tools Rate Thread
Old 11-03-2008, 04:21 PM   #1
WvHilltop
Guest
 
Posts: n/a
Default 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.
  Reply With Quote
Old 11-03-2008, 10:22 PM   #2
Mike Middleton
Guest
 
Posts: n/a
Default Re: 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" <WvHilltop@discussions.microsoft.com> wrote in message
news:FF333D19-8DD4-46FB-A154-06A2DF6ED420@microsoft.com...
>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.



  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off