I need help with charts!

  • Thread starter Thread starter Heather
  • Start date Start date
H

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???????
 
Hi Heather,

The quickest way to get the chartwizard to work is to clear the cell
containing the word Years. Currently the wizard thinks you have 2 sets
of data.

Also Jon's Chart tutorial maybe useful to you.
(http://peltiertech.com/Excel/ChartsHowTo/index.html)
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???????
Click to expand...

--

Cheers
Andy

http://www.andypope.info
 
Back
Top