I need help with charts!

[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???????

 

[gmangad]

Hi

instead of entering the year as a number , try to enter the year as a
string (eg:- '1990) or you may enter the year as "Y 1990"
.. Find an attached file with an example

regards
gt

Attachment filename: book2.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=398044

 

[Andy Pope]

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???????

--

Cheers
Andy

http://www.andypope.info

 

[Andy Pope]

Should have read Heather's other post first, which Debra answered with
spooky similar advice

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)

--

Cheers
Andy

http://www.andypope.info

 

[Jon Peltier]

Great minds think alike!

- Jon