Stack area partially in line or combo charts

[Enriquemmesteo]

Hello, this should be a simple thing to do but I haven't found the right solution today.

Let's say I have a field with the number of sales. Another field tells me if they are internal or internal. And then there is another field called Budget sales(Internal/External doesn't apply on these).

I need to show the budget sales as a line, and then the external and internal sales as stacked area. I've tried this with Vizlib visualizations too but either I stack all three or none of them.

Thanks!

[lironbaram · Accepted solution]

hi 

there is a limitation in bar chart or combo chart when you have two dimensions , you can only have one measure 

but in your case if the second dimension has only two values 

you can use combo chart with 3 measures 

where your sales measures will be split to internal sales and external sales , and you have budget 

then you can stack the sales measures and the display the budget as line 
something like this 

if you want it as lines and areas you can do it in vizlib line chart like this 

[Enriquemmesteo]

The second one is exactly what I was looking for! is this the normal combo chart? How did you stack only two?