M Mr M New Member Dec 28, 2010 #1 Hello, I am trying to overlay actual data vs. planned data (by month) for four sets of data using a stacked column chart. I have not problem doing it for each data set, but didnt know if there was a way to combine it all in one chart. Thanks in advance for any assistance. Matt
Hello, I am trying to overlay actual data vs. planned data (by month) for four sets of data using a stacked column chart. I have not problem doing it for each data set, but didnt know if there was a way to combine it all in one chart. Thanks in advance for any assistance. Matt
K keymaster New Member Dec 29, 2010 #2 Can you post a sketch / drawing of what you are trying to achieve...
Hui Excel Ninja Staff member Dec 29, 2010 #3 @Mr M. If your using stacked column remember that the values need to be cumulative ie if your values are 90,100, 150 and 180 then you need to be changing the data to be 90, 10,50,30
@Mr M. If your using stacked column remember that the values need to be cumulative ie if your values are 90,100, 150 and 180 then you need to be changing the data to be 90, 10,50,30
