atw: Re: Excel question: year-based charts

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

Naomi wrote:
NK> provide a heading for the numbers column, 
NK> but NOT the years column

Thanks Naomi, that worked a treat!

I experimented a bit, and it seems you can even select
a blank cell above each column (without column
headings) and that works too.

Howard wrote:
HS> start the Chart Wizard and then 
HS> click on the "XY (Scatter)" option

Thanks Howard, that worked too. For some reason, Excel
added 2001 and 2006 to the X axis (without a plot
above them). I found you can then right-click on the
chart body or background, choose Chart Type, and
choose Column, and you get the same result as you do
when you select a blank cell above each column -- 2001
and 2006 disappear again from the X axis.

Very curious results, but handy to know when you want
to make a chart of changes over time!

Thanks again,
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: