software

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: www.excelforum.com/attachment.php?postid=4744 |
-------------------------------------------------------------------

--
Cossminnn
------------------------------------------------------------------------
Cossminnn's Profile: www.excelforum.com/member.php...oamp;userid=34309
View this thread: www.excelforum.com/showthread...hreadid=540764Let'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 C180 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

quot;Cossminnnquot; gt; wrote
in message ...
gt;
gt; I have a list with movies and the years they were released in. How can I
gt; create a chart that has on the oX axis the years and on oY the number of
gt; movies released in each year?
gt;
gt; I'd like it to look as shown in the attached image. Thanks for your
gt; help.
gt;
gt;
gt; -------------------------------------------------------------------
gt; |Filename: chart.JPG |
gt; |Download: www.excelforum.com/attachment.php?postid=4744 |
gt; -------------------------------------------------------------------
gt;
gt; --
gt; Cossminnn
gt; ------------------------------------------------------------------------
gt; Cossminnn's Profile:
gt; www.excelforum.com/member.php...oamp;userid=34309
gt; View this thread: www.excelforum.com/showthread...hreadid=540764
gt;

Yes, thanks. I think that should do it.--
Cossminnn
------------------------------------------------------------------------
Cossminnn's Profile: www.excelforum.com/member.php...oamp;userid=34309
View this thread: www.excelforum.com/showthread...hreadid=540764