atw: SEC: UNCLASSIFIED RE: Excel question: year-based charts

Craig

The trick is to select the data as you describe, start the Chart Wizard and
then click on the "XY (Scatter)" option. Then Excel should give you what you
want.

Otherwise it assumes the two columns are both data series with four
observations.

Howard

-------------------------------
Howard L. Silcock
Technical Writer
Project Office - Infrastructure
Department of Defence
(02) 626 58828  
--------------------------------




-----Original Message-----
Date: Tue, 26 Apr 2005 12:21:20 +1000 (EST)
From: Craig Hadden <craig_john_hadden@xxxxxxxxxxxx>
Subject: 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

------------------------------

End of austechwriter Digest V3 #106
***********************************
**************************************************
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: