# Assigning values to the x axis of a graph

#### gaz@downunder

##### New Member
The data I am trying to graph is as follows:
Age Incidence
0-4 5
5-9 4
10-14 12
14-19 14
20-24 11
25-29 6
I am trying to create a simple line graph that will show a peak at the age range of 14-19. When I create the graph, it has 1,2,3,4,5,6 along the x axis instead of the age ranges that I need. Thanks.

### Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
hi gaz
can't think what it would be - i tried with your sample and couldn't duplicate the problem.
how is your data arranged - more or less as you posted it? how is it formatted (number,text, etc)? what sort of chart are you using?
can you describe what procedure you are following in the chart wizard to graph it?
anno

If the following data is entered into cells A1:B7...

{"Age","Incidence"
;"0-4",5
;"5-9",4
;"10-14",12
;"14-19",14
;"20-24",11
;"25-29",6}

...this chart SERIES function should do the trick...

=SERIES(,Sheet2!\$A\$2:\$A\$7,Sheet2!\$B\$2:\$B\$7,1)

Replies
2
Views
618
Replies
1
Views
196
Replies
0
Views
233
Replies
1
Views
213
Replies
9
Views
347

1,207,093
Messages
6,076,545
Members
446,212
Latest member
KJAYPAL200

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back