I have a Pivot Table and Chart that display our Budget, Current Sales, and Projected Sales. My boss wants the Current Sales and Projected Sales to merge, but with different coloured bars, to compare against the Budget. Any ideas?
.---.
......
...... .---.
...... ......
...... ......
...... .---.
...... ......
Budget
VS
Current
+
Projected
.---.
......
...... .---.
...... ......
...... ......
...... .---.
...... ......
Budget
VS
Current
+
Projected