I'm trying to set up a bar chart so that the two totals are stacked somewhat as you see below. The goal is to have the orange, in this case 84%, show first and the second value, 16% in this example, show second. The data is pulling from a Pivot table. If I switch the order of the Values in the PivotChart Fields I get the second example below where the visual aspect comparing the 84% vs 16% is not accurate. How can I fix this?
Thanks in advance
Thanks in advance