MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel Newbie

Posted by Alex Divers on February 08, 2002 9:40 AM

Hi, I'm currently working with Excel on a database of challenging behaviour with a client of mine. I have the days of the month in my first column and the months in my first row. In the cells is the duration of behaviour in minutes. However when I try to chart the figures the chart appears to add up the mins. For example if the mins were 20 on 18th Jan and 30 on the 18th of Mar the graph shows a period of 50 occuring on the 18th. Can you tell me how I would get a yearly graph with each month individually mapped?
Thanks for any help Alex

Posted by CurtisH on February 08, 2002 10:19 AM

Don't use a stacked bar chart. I tried it with a column chart and it worked fine.