atw: Excel question: year-based charts

I've got an Excel question that I hope someone can
answer. (Apologies that this is slightly off-topic. My
excuse is that it's come about when preparing charts
for a newsletter.)

Suppose I have a list of figures like the following:

2002 4
2003 8
2004 11
2005 13

I want to make a chart with the years across the X
axis and the other figures up the Y axis.

I thought it would be a simple matter in Excel ? I'd
just select the data, click the Chart Wizard button
and click Finish, and BINGO. Unfortunately, those
simple steps didn't work!

I asked a few people, and someone came up with the
following:

In the second step of the Chart wizard, click the
Series tab, click Remove to delete series 1, click in
the "Category (X) axis labels" field, select the years
in the workbook, and then click Finish.

Is this task really so obscure in Excel, or is there a
more intuitive way?

Thanks,
Craig 

===== My e-mail address is:
===== craigh(at)attachesoftware(dot)com
===== (I may not see messages sent to my Yahoo address)

Find local movie times and trailers on Yahoo! Movies.
http://au.movies.yahoo.com
**************************************************
To post a message to austechwriter, send the message to 
austechwriter@xxxxxxxxxxxxxx

To subscribe to austechwriter, send a message to 
austechwriter-request@xxxxxxxxxxxxx with "subscribe" in the Subject field.

To unsubscribe, send a message to austechwriter-request@xxxxxxxxxxxxx with 
"unsubscribe" in the Subject field.

To search the austechwriter archives, go to 
www.freelists.org/archives/austechwriter

To contact the list administrator, send a message to 
austechwriter-admins@xxxxxxxxxxxxx
**************************************************

Other related posts: