creating a chart

[heather]

I am trying to create a column chart on Excel displaying
Years VS. $ in Billions. The problem is that I only want
one column which will display the amount in Billions. I
want the columns to be labeled by year on the horizontal
axis.

For example:
Years $ in billions
1990 200
1991 215
1992 220
1993 450
1994 520

When I select the range to be graphed, I highlight both
columns but then I get to columns and on the horizontal
axis its labled 1,2,3,4 etc. instead of the years....how
do I make it so it graphs the amount in Billions but it
labels the correct year underneath? Does anyone know
how???????

 

[Debra Dalgleish]

Remove the heading from the Years column, select the cells, and click
the Chart Wizard button. (An empty cell at the top left makes it easier
for Excel to create the column chart correctly.)

Jon Peltier has a webs site with lots of charting information, including
a page on setting up the data:

http://www.peltiertech.com/Excel/ChartsHowTo/Charting101.html