changing the x axis in a scatter plot
 

I'm trying to graph this:

on x axis: on y axis:
age class log10 survivorship
0-9 3
10-19 2.98
20-29 2,98
30-39 2.93

When i graph it the x axis has numbers like 1, 2, 3, 4, 5, 6, 7, etc;
doesn't have the 0-9 thing going on. Now...is it possible to make it 0-9,
10-19, 20-29, etc on the x-axis? Thanks in advance!!

changing the x axis in a scatter plot
 

Hi,

An xy scatter is expecting a pair of values, as the name suggests, an x
and y value.
You have a band of values for your x's.

Try using a Line chart in order to get a category x axis.

Cheers
Andy

Trian wrote:
I'm trying to graph this:

on x axis: on y axis:
age class log10 survivorship
0-9 3
10-19 2.98
20-29 2,98
30-39 2.93

When i graph it the x axis has numbers like 1, 2, 3, 4, 5, 6, 7, etc;
doesn't have the 0-9 thing going on. Now...is it possible to make it 0-9,
10-19, 20-29, etc on the x-axis? Thanks in advance!!


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info