X Axis?
 

I'm trying to create a graph where my X Axis list various contries. For some
reason my X axis is reading as numbers instead of countries. The source data
is pulling from the correct cells where I listed the countries. Can someone
tell me how I can fix it?? Thanks.

X Axis?
 

Line or Column chart?
Can't be an XY since that need numbers for the x-axis.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"tt_Gyrl" wrote in message
...
I'm trying to create a graph where my X Axis list various contries. For
some
reason my X axis is reading as numbers instead of countries. The source
data
is pulling from the correct cells where I listed the countries. Can
someone
tell me how I can fix it?? Thanks.

X Axis?
 

Hi Bernard-
It's a scattered chart. I'm trying to duplicate a chart in a magazine using
the same data. Everything looks good but I need to change the X Axis labels
to read the countries. Help? Thanks.

"Bernard Liengme" wrote:

Line or Column chart?
Can't be an XY since that need numbers for the x-axis.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"tt_Gyrl" wrote in message
...
I'm trying to create a graph where my X Axis list various contries. For
some
reason my X axis is reading as numbers instead of countries. The source
data
is pulling from the correct cells where I listed the countries. Can
someone
tell me how I can fix it?? Thanks.

X Axis?
 

An XY (Scatter) chart needs numeric data in x-values
Change it to a Line chart by right clicking and opening Chart Type dialog
A Line chart does no have to have a line - it can have just markers
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"tt_Gyrl" wrote in message
...
Hi Bernard-
It's a scattered chart. I'm trying to duplicate a chart in a magazine
using
the same data. Everything looks good but I need to change the X Axis
labels
to read the countries. Help? Thanks.

"Bernard Liengme" wrote:

Line or Column chart?
Can't be an XY since that need numbers for the x-axis.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"tt_Gyrl" wrote in message
...
I'm trying to create a graph where my X Axis list various contries. For
some
reason my X axis is reading as numbers instead of countries. The source
data
is pulling from the correct cells where I listed the countries. Can
someone
tell me how I can fix it?? Thanks.

X Axis?
 

Bernard...it worked! You're a genius! Thanks.

Mary Ann

"Bernard Liengme" wrote:

An XY (Scatter) chart needs numeric data in x-values
Change it to a Line chart by right clicking and opening Chart Type dialog
A Line chart does no have to have a line - it can have just markers
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"tt_Gyrl" wrote in message
...
Hi Bernard-
It's a scattered chart. I'm trying to duplicate a chart in a magazine
using
the same data. Everything looks good but I need to change the X Axis
labels
to read the countries. Help? Thanks.

"Bernard Liengme" wrote:

Line or Column chart?
Can't be an XY since that need numbers for the x-axis.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"tt_Gyrl" wrote in message
...
I'm trying to create a graph where my X Axis list various contries. For
some
reason my X axis is reading as numbers instead of countries. The source
data
is pulling from the correct cells where I listed the countries. Can
someone
tell me how I can fix it?? Thanks.

X Axis?
 

I'll tell that to wife next time I burn the toast.
Thanks
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"tt_Gyrl" wrote in message
...
Bernard...it worked! You're a genius! Thanks.

Mary Ann

"Bernard Liengme" wrote:

An XY (Scatter) chart needs numeric data in x-values
Change it to a Line chart by right clicking and opening Chart Type dialog
A Line chart does no have to have a line - it can have just markers
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"tt_Gyrl" wrote in message
...
Hi Bernard-
It's a scattered chart. I'm trying to duplicate a chart in a magazine
using
the same data. Everything looks good but I need to change the X Axis
labels
to read the countries. Help? Thanks.

"Bernard Liengme" wrote:

Line or Column chart?
Can't be an XY since that need numbers for the x-axis.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"tt_Gyrl" wrote in message
...
I'm trying to create a graph where my X Axis list various contries.
For
some
reason my X axis is reading as numbers instead of countries. The
source
data
is pulling from the correct cells where I listed the countries. Can
someone
tell me how I can fix it?? Thanks.