Pareto, split total bar and make it in stacked manner

[Manojlo]

Is it possible to create Pareto, and instead values in total column, to make bars from values from two column.

For example, in first column (New York) instead value 12, I want to have two values 5 (left) + 7 (right), and for others

 

[AhoyNC]

The only way I can think of would be to build the graph from the Stacked Column charts.
You would want your totals to be in descending (like you have them).
Then add a percent column and a cumulative percent column.

-Then highlight columns City, Left, Right, and Cum. %
-Under charts select Stacked Column
-Then right click on one of the bars and choose "Change Series Chart Type"
-From this option change the Cum % to line chart and plot to secondary Axis.
-Then under under Format change the Gap Width

 

[Manojlo]

The only way I can think of would be to build the graph from the Stacked Column charts.
You would want your totals to be in descending (like you have them).
Then add a percent column and a cumulative percent column.

-Then highlight columns City, Left, Right, and Cum. %
-Under charts select Stacked Column
-Then right click on one of the bars and choose "Change Series Chart Type"
-From this option change the Cum % to line chart and plot to secondary Axis.
-Then under under Format change the Gap Width

View attachment 21979
View attachment 21980

Thank you very much