Help with Stacked Graph or Similiar

[drue76]

Hello,

I am trying to create a graph that displays two sets of data, with one set of the data being a portion of the other. For example, for each month in 2013, I would like to display the total time from A to C as my first data point and my second data point, would be the total time from B to C. I was trying to create a stacked graph that showed one bar with the total time A to C and within that bar, I could show the portion of time that was B to C. However, if I attempt to display this as a stacked graph, it treats the numbers as seperate and instead of one being a portion of the other, it just adds them together. I hope this is clear...

Is there a way to display a bar graph, or something similiar to show total time and than portions of the time?

I am using Excel 2010 on Windows.

Thank you!
Andrea

[judgeh59]

Hi Andrea and welcome to the forum --

can you attach a file to play with?....please remove any company confidential info....thanks....