Hello,
In Excel 2007, I am trying to create a line graph of 2 years worth of data the x axis is the months and the y axis is pounds. The line depicts amount of pounds sent the the company each month. Half way through the second year, we started tracking what should have been going there and what should not have been going there. I would like to depict this in the bar graph that stacks the 2 sets of data into one bar (but seperated by colors). I want these 2 graphs together.
Any ideaS?
In Excel 2007, I am trying to create a line graph of 2 years worth of data the x axis is the months and the y axis is pounds. The line depicts amount of pounds sent the the company each month. Half way through the second year, we started tracking what should have been going there and what should not have been going there. I would like to depict this in the bar graph that stacks the 2 sets of data into one bar (but seperated by colors). I want these 2 graphs together.
Any ideaS?