Simple graph

A

Ant

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.
 
A

Andy Pope

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Getting the graph style I want 4
Make Y-axis values correspond to x- axis value 1
Combining a 2-D column graph and a 2-D line graph on the same char 3
Y axis data point alignment with x axis dates 0
Stack bar charts with positive and negative numbers 2
today line on graph 1
Create a bar graph with three sets of labels 3
Graphing calender chart with combined relative amounts for each date 0

Top