| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need PivotChart x axis to cross Y axis at minimum Y axis value | Charts and Charting in Excel | |||
| TO CREATE A LINE CHART WITH RATE IN Y AXIS & REAL TIME IN X AXIS | Charts and Charting in Excel | |||
| can I make the vertical axis the category axis in Excel line graph | Charts and Charting in Excel | |||
| How to insert X axis scale values next to axis and X axis grid lin | Charts and Charting in Excel | |||
| Secondary Axis Annual Units sold on 1 Y Axis - Dollar Volume on another | Charts and Charting in Excel | |||
Linear Mode
