Scatter plot
 

How do i print data on the x-axis os scatter plot like in bar chart?

Example
Following is my data

header1 header2
"jan" 2
feb 3
mar 5
apr 6
may 55
june 10
jul 12
aug 33
sept 34
oct 45
nov 50
Dec 33

when i plot "header1" on x-axis vs "header2" on y -axis, as scatter plot,
instead of jan,feb,mar, i get numbers 2,4,6 on x-axis of the scatter plot.

How do i get the actual strings printed on the x-axis?
I want the months to be seen on the x-asis when i plot them

Thanks
Mala

Scatter plot
 

On Mon, 15 Sep 2008, in microsoft.public.excel.charting,
Mala said:
How do i print data on the x-axis os scatter plot like in bar chart?

when i plot "header1" on x-axis vs "header2" on y -axis, as scatter plot,
instead of jan,feb,mar, i get numbers 2,4,6 on x-axis of the scatter plot.

99 times out of a hundred, people turn out to be inappropriately using a
Line Chart type when they should be using a Scatter Chart type. I think
you're the very first poster I've ever seen pose a question where it
turns out that the scatter chart is the wrong one and line chart is
right.

Don't worry if you only want symbols and not lines, you can easily get
rid of the lines in a "line" chart; the principal difference between the
two types is that the line chart has a category x axis (as you say, like
a bar chart).

The other thing you need to do, that Microsoft never warns you, is leave
the cell above the x axis range blank: take the "header1" label away.
You can put it back later, but the wizard is looking for the blank to
tell it what goes in the x axis.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.