Need non-overlapping Stacked Column charts in pivot charts

I have pivot table giving me the sales by region and corresponding percentages for a particular year. When I try to create a stacked column pivot chart,both the charts overlap (As in attached pic). Can someone help me in putting them in two separate stacked charts grouped by year

stack.png

I'm sure we can help you, but it is difficult to make specific suggestions based only on a picture of the chart. A sample file uploaded to the forum would be better.

What your picture shows is typically how Excel displays column charts when some columns are on the secondary axis. If I understand what you want, I think you will need a "clustered and stacked" column chart technique like this: https://peltiertech.com/clustered-st...mn-bar-charts/ Note that much of the work is arranging the data in the spreadsheet. I don't know that a pivot table is going to readily want to arrange itself in this way, so you may need to use worksheet formulas to extract the data from the pivot table into the arrangement shown. Then create the stacked column chart from this range and format as desired (with the desired stacks on the secondary axis).