graph question - easy

[Bryce]

I just want to have the year on the x axis, and the dollar amounts (property
taxes) on the y axis.

2003 6,254,256
2002 5,977,623
2001 5,710,123
2000 5,411,618
1999 5,082,506
1998 4,722,586
1997 4,570,988
1996 4,293,010
1995 4,010,103
1994 3,718,653
1993 3,476,759
1992 3,100,151
1991 2,842,230
1990 2,500,087
1989 2,359,013
1988 2,145,568
1987 2,042,279
1986 1,784,467
1985 1,678,405
1984 1,508,700
1983 1,434,255
1982 1,242,771
1981 1,129,004
1980 1,006,737


I can't get the x axis to show 1980, 1981, 1982, etc. It only is giving me
1,2,3,4,5.... etc. How to I address this?

Thanks.

 

[Debra Dalgleish]

Add a heading to the column of dollar amounts,

Amount
2003 6,254,256
2002 5,977,623

then use the chart wizard to create the chart. Excel should do a better
job of detecting your labels.

Jon Peltier has information on creating charts that may help you:

http://www.geocities.com/jonpeltier/Excel/ChartsHowTo/Charting101.html

 

[Bryce]

thank you.

Add a heading to the column of dollar amounts,

Amount
2003 6,254,256
2002 5,977,623

then use the chart wizard to create the chart. Excel should do a better
job of detecting your labels.

Jon Peltier has information on creating charts that may help you:

http://www.geocities.com/jonpeltier/Excel/ChartsHowTo/Charting101.html

 

[Max]

Try this:

Right-click on the chart > Source Data > Series tab

Click inside the box for "Category (X) axis labels"
Select the year column range
(i.e. select the "2003, 2002 .... 1980" range)

Click OK

(Sort by the year column > Ascending
if you want the chart to read from 1980 .... 2003)

 

[Bryce]

under the Category (X) axis lables, how can I reference years 1980 - 2005
without having to go like {1980,1981,1982,1983 all the way to 2003?


isn't there a sign I can put between 1980 and 2003 for it to know to put the
entire string in there?

thanks.

 

[Max]

Perhaps you might have misunderstood the steps given

After putting the cursor inside
the box for "Category (X) axis labels"
you can actually click outside the dialog box and
select the year range on the sheet itself

Let's assume your data range is in Sheet1, in A2:B25
(i.e. A2:A25 contains the years: 2003....1980)

Put in Category (X) axis labels: =Sheet1!$A$2:$A$25

(You'll get the same range in the box, viz. "=Sheet1!$A$2:$A$25"
if you do it via the earlier steps given)

 

[Bryce]

oh, I SEE!

got it. thanks!

Perhaps you might have misunderstood the steps given


After putting the cursor inside
the box for "Category (X) axis labels"
you can actually click outside the dialog box and
select the year range on the sheet itself

Let's assume your data range is in Sheet1, in A2:B25
(i.e. A2:A25 contains the years: 2003....1980)

Put in Category (X) axis labels: =Sheet1!$A$2:$A$25

(You'll get the same range in the box, viz. "=Sheet1!$A$2:$A$25"
if you do it via the earlier steps given)

 

[Max]

you're welcome, Bryce!

cheers
Max