How can this be done?
 

I have a list with movies and the years they were released in. How can I
create a chart that has on the oX axis the years and on oY the number of
movies released in each year?

I'd like it to look as shown in the attached image. Thanks for your
help.


+-------------------------------------------------------------------+
|Filename: chart.JPG |
|Download: http://www.excelforum.com/attachment.php?postid=4744 |
+-------------------------------------------------------------------+

--
Cossminnn
------------------------------------------------------------------------
Cossminnn's Profile: http://www.excelforum.com/member.php...o&userid=34309
View this thread: http://www.excelforum.com/showthread...hreadid=540764

How can this be done?
 

Let's say the titles are in column A and the year of release in B
Leave C1 empty and in D1 enter the text Movies
In C2:C80 enter years such as 1930, 1931, 1932 .....
In D2 enter =COUNTIF(B:B,C1) and copy this down the column by double
clicking the D2's fill handle (small solid square in bottom right corner of
active cell)
Select C1:D80 and make a Line or column chart
best wishes - come back if more needed
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Cossminnn" wrote
in message ...

I have a list with movies and the years they were released in. How can I
create a chart that has on the oX axis the years and on oY the number of
movies released in each year?

I'd like it to look as shown in the attached image. Thanks for your
help.


+-------------------------------------------------------------------+
|Filename: chart.JPG |
|Download: http://www.excelforum.com/attachment.php?postid=4744 |
+-------------------------------------------------------------------+

--
Cossminnn
------------------------------------------------------------------------
Cossminnn's Profile:
http://www.excelforum.com/member.php...o&userid=34309
View this thread: http://www.excelforum.com/showthread...hreadid=540764

How can this be done?
 

Yes, thanks. I think that should do it.


--
Cossminnn
------------------------------------------------------------------------
Cossminnn's Profile: http://www.excelforum.com/member.php...o&userid=34309
View this thread: http://www.excelforum.com/showthread...hreadid=540764