Thread: Scatter plot
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Mala Mala is offline
external usenet poster
 
Posts: 1
Default 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