Excel 2008 : Combine Chart Types in 2008

**kshetty** · 06-28-2011, 09:25 AM

I'd like to illustrate a comparison between two products each with two values each for 5 different time periods thus incorporating a stacked clustered chart in a waterfall format.

Each total value for each time period for each product is split 2/3 v 1/3 -- stacked option
There are two products for each time period - cluster option
I'd like show Hour 1 through Hour 5 separately but as a total figure - waterfall option

Please contact me if more info is needed to assist.

Thanks in advance for your help

**romperstomper** · 06-28-2011, 09:29 AM

I think a sample workbook would help.

Note: I have moved your question to the Excel 2008 forum (it definitely didn't belong in the Programming forum given the lack of VBA)

**kshetty** · 06-28-2011, 09:42 AM

Initially posted it there due to the charting sub forum.

As suggested, a file is attached which should help illustrated the various data points.

**romperstomper** · 06-28-2011, 09:48 AM

I'll leave it here for a bit since 2008 is quite different from Windows versions (in a bad way) but if there's not much response, feel free to post a link in the Charting subforum (not in the Programming forum itself)