combined chart

Hi everyone,

I've got anmast annoyed issue to find the way to combine bar stacked chart 100 % normalized and line chart together. I'm sure it's possible but I can't find the deal. I attached two pictures before and after (the goal).

If anyone has already did that, let me know,

Thx in advance,

Christophe

Find more posts tagged with

Comments

mwilliams

Hi Christophe,

I've never ran into this issue myself, so I had never tried it. It doesn't seem that there's a way to switch a second series to a line style when you're using a normalized bar chart. In standard bar charts, you can.

You might be able to do a standard bar chart and do the normalization of the values yourself so that you can use the line chart option for a series still. I haven't done this yet, so I'm not sure if this will work, but it's a possible option.

cdoniat

Hi Michael,

Thanks for your reply.

I'm surprising because each Y axis should be independent from each other.

BTW, is it possible to tell something like stacked = false to the line chart? I did, but the chart can't display anymore.

To normalize, I googled but I didn't find the fitted solution. Any suggestion?

Regards,

Christophe

mwilliams

Christophe,

Doing it yourself, I just meant setting the scale to 100 and normalizing the values to that yourself. Though, I have not checked to see if you can have a line chart with a regular stacked bar chart.