Mixing Area and Column Chart

**paranoid.android** · 12-14-2011, 10:31 AM

Hello,

I like the way a stacked (not 100%) column chart looks, but I need the functionality of the Area chart. I am currently trying to display Monthly Revenue and Expenses. The Revenue will almost always be larger than the expenses. Because of this, I want the expenses series on top of the revenue series. When I try to create a column chart though, the two series values are added to one another. For instance, if the monthly Revenue is 100,000 and the Expenses are 20,000, the column shows a total of 120,000. Is there a way to accomplish this?

Thank you!

**teylyn** · 12-17-2011, 06:37 PM

Hello,

have you tried the stacked area chart?

**Andy Pope** · 12-21-2011, 10:19 AM

Either plot as cluster column and set the overlap to 100.

Or move one of the series to the secondary axis. Delete the secondary value axis to force both series to use the same scale