Thread: 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.

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" <Cossminnn.27lsum_1147284607.0102@excelforum-nospam.com> wrote
in message news:Cossminnn.27lsum_1147284607.0102@excelforum-nospam.com...
>
> 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
>

Yes, thanks. I think that should do it.