What I have is data for January through Decemer for the years 2002 -
2005. Now I need to start seperating data for each month in two
catagories. I don't even know if it is possible to have a stacked
column chart. I need a chart that shows at the bottom each month
grouped together with a series for each year. Then starting in June of
2005, showing two values in one series stacked. Like all this time
until June 2005 we were counting cookies and candy as sales together
but now we want to show in the single series stacked the total of
cookies and candy.


--
Ann Kelley
------------------------------------------------------------------------
Ann Kelley's Profile: http://www.excelforum.com/member.php...o&userid=27590
View this thread: http://www.excelforum.com/showthread...hreadid=471114