Simple graph

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ant - 24 Aug 2006 04:50 GMT

I have a range of data corresponding to several years:

Year Amount
1997 100
1998 150
1999 200
2000 250 etc

How can I display a graph with this range that shows the amounts in a bar
graph on the Y axis and the years along the bottom on the X axis. If I use
the wizard it tries to compare 1997 to 100 which is obviously not what I want
to do.

Reply to this Message

Andy Pope - 24 Aug 2006 08:43 GMT

Hi,

The quickest way is to clear the cell that contains the word Year and
then use the wizard.

Excel is trying to help you, although not successfully, by using the
column headers as a clue that you have two data series.

Cheers
Andy

> I have a range of data corresponding to several years:
>
[quoted text clipped - 8 lines]
> the wizard it tries to compare 1997 to 100 which is obviously not what I want
> to do.

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Reply to this Message