Axis display as category
 

I am desiring to display a chart with the X Axis being cards from a deck of
playing cards and Y Axis as number of times receiving these in a game.
However Excel chart insists on displaying my Ah, Kh, etc as a number 1 - 52
instead of the actual text in the column. All of the radio button
selections to format this to "category" are grayed out..ARGH!

How would one force Excel to display the actual text in the column instead
of counting numbers?

TIA

Forgot to mention I want it as a XY scatter graph. Bar charts display as
text as is desired.


"doco" wrote in message
...
I am desiring to display a chart with the X Axis being cards from a deck of
playing cards and Y Axis as number of times receiving these in a game.
However Excel chart insists on displaying my Ah, Kh, etc as a number 1 - 52
instead of the actual text in the column. All of the radio button
selections to format this to "category" are grayed out..ARGH!

How would one force Excel to display the actual text in the column instead
of counting numbers?

TIA

You'll have to use a line chart and format the series to remove the line.
XY scatter charts must have numeric values on both axes but you can use a
category axis with a line chart.

Andrea Jones
www.allaboutoffice.co.uk

"doco" wrote in message
...
Forgot to mention I want it as a XY scatter graph. Bar charts display as
text as is desired.


"doco" wrote in message
...
I am desiring to display a chart with the X Axis being cards from a deck
of
playing cards and Y Axis as number of times receiving these in a game.
However Excel chart insists on displaying my Ah, Kh, etc as a number 1 -
52
instead of the actual text in the column. All of the radio button
selections to format this to "category" are grayed out..ARGH!

How would one force Excel to display the actual text in the column
instead
of counting numbers?

TIA

Thank you.

"Andrea Jones" wrote in message
...
You'll have to use a line chart and format the series to remove the line.
XY scatter charts must have numeric values on both axes but you can use a
category axis with a line chart.

Andrea Jones
www.allaboutoffice.co.uk

"doco" wrote in message
...
Forgot to mention I want it as a XY scatter graph. Bar charts display as
text as is desired.


"doco" wrote in message
...
I am desiring to display a chart with the X Axis being cards from a deck
of
playing cards and Y Axis as number of times receiving these in a game.
However Excel chart insists on displaying my Ah, Kh, etc as a number 1 -
52
instead of the actual text in the column. All of the radio button
selections to format this to "category" are grayed out..ARGH!

How would one force Excel to display the actual text in the column
instead
of counting numbers?

TIA

Alternatively, you could use Rob Bovey's XY Chart Labeler at www.appspro.com

"doco" wrote in message
...
Forgot to mention I want it as a XY scatter graph. Bar charts display as
text as is desired.


"doco" wrote in message
...
I am desiring to display a chart with the X Axis being cards from a deck
of playing cards and Y Axis as number of times receiving these in a game.
However Excel chart insists on displaying my Ah, Kh, etc as a number 1 -
52 instead of the actual text in the column. All of the radio button
selections to format this to "category" are grayed out..ARGH!

How would one force Excel to display the actual text in the column
instead of counting numbers?

TIA