Category on x -axis of xy scatter graph

QuestionEdit

Thanks for pointing me to http://peltiertech.com/ but I can't get it to work by following their instructions. I can use category as my x-axis if I use a line graph but it defaults to numerical value when I use xy scatter graph. Can you help me.

The expert can't answer your question.

Your Question was:

How do I create a scattered graph with the a legend showing a set of A, B, and C data points and the X-axis label displaying the Joint # (i.e. B020(6)) instead of a numerical value.

Joint # A B C B020(6) 3 1 29.4 B020(12) 4 1 23 B021(6) 5 83.15 32 B021(12) 2 36.94 3 B023(6) 4 2 52.29 B023(12) 2 2 2 B024(6) 34 23 3 B024(12) 3 24.97 3 B025(6) 34 4 4 B025(12) 3 4 54.44 B026(6) 3 98 3 B026(12) 4 7 3 B027(6) 4 3 2 B027(12) 65 3 2 B028(6) 7 3 3 B028(12) 7 7 3 B029(6) 3 3 2 B029(12) 3 3 20.18

Following is the reason:

http://peltiertech.com/

has all the answers on charting.

Expert: Tom Ogilvy

If you'd like to ask another question in the category, please come to http://www.allexperts.com/browse.cgi?catLvl=3&catID=1059

This message is sent by an autoresponder and cannot process replies.

AnswerEdit

Mike can you send me a sample workbook with your data and the chart as it is now. Also in the email include what your specific question was (what labels you want).

Tell me what version of(very important)

If you have a link to the specific page on Jon's site (that you were refering to) include that in the email as well.

send to