| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
