I am trying to make a graph and i am not sure if that's possible. I have three data series in three columns. Column A is labeled profit 2007, column B is labeled Profit YTD July 2008 and column C is labeled Forecase Profit 2008. When i do a column graph, it give me three columns, one for each data series. What i want to do is have only TWO columns, one for Profit 2007 and a second one that will picture Profit YTD and Forecast profit in one double-coloured column. In a way, i want to have something between the clustered and stacked column graphs offered by Excel.
Any help will be appreciated.
thanks
Bookmarks