How do you combine in a single chart a clustered column, stacked column and line with markers?

[vdrl29]

Hello everyone,
I want to ask if there is a way to have in a single chart a combination of a clustered, stacked columns and a line with markers.
I have been doing attempts by using the axis with no success.
Your help is highly appreciated.

Wk23 Wk24 Wk25 Wk26 Wk27 Wk28
Paused 10 4 7 9 8 11
Delivered 11 26 29 35 33 21
Not Delivered 1 4 3 5 2 3
On Time 92% 88% 86% 86% 81% 78%

What I am trying to do is to have the Paused as a single column, next to it stacked with Deliver and Not Delivered, and through a second axis the % as a line on top of the columns.

Best Regards

Post Moved by Moderator.
.

 

[vletm]

Could You make any kind of visual image of Your vision with those values?

 

[vdrl29]

Sure thing,
Please refer to the attached document as a sample.
Regards,

 

[vletm]

something to preview ....
You can edit values to test it.

 

[Gregor]

Hi,

Not sure if this actually answers the task set but....

If you change the chart type on the 'paused' date to a line with markers and remove the lines leaving only markers you get a dot on your original stack bar.

To me, the advantage of this is that is stays on the same scale as your stack data and leaves your secondary axis for your 'on-time' percentage data.

My first reply - please let me know if all okay?

 

[vdrl29]

Hello Gregor,
Thank you for the reply. It is a different approach that can work for the purpose.

Thank you vletm for your file and reply.

Best Regards,