Pivot table chart formatting
I am using pivot table on a data set showing sales by month.
I want to automate some of the charts for this but find that when I create a pivot chart the axes are the wrong way round and cannot be switched.
If the data is pasted as values and then charted, the axes work fine (months left to right, product groups top to bottom.
The data set is below for reference.
| Sum of Ttl Base | Column Labels | |||||||||||||||
| Row Labels | 11 06 | 11 07 | 11 08 | 11 09 | 11 10 | 11 11 | 11 12 | 12 01 | 12 02 | 12 03 | 12 04 | 12 05 | 12 06 | Grand Total | ||
| FACT | 260 | 1033 | 1036 | 1280 | 620 | 5120 | 2925 | 3695 | 520 | 8995 | 14380 | 4460 | 900 | 45224 | ||
| SERV | 4370 | 1730 | 2205 | 8015 | 2627 | 8090 | 300 | 595 | 7690 | 137 | 580 | 9565 | 0 | 45904 | ||
| SPARES | 228 | 760 | 3261 | 483 | 1138 | 1711 | 2879 | 1466 | 113 | 2631 | 547 | 15217 | ||||
| Grand Total | 4858 | 3523 | 6502 | 9295 | 3730 | 14348 | 3225 | 6001 | 11089 | 10598 | 15073 | 16656 | 1447 | 106345 | ||
 Bitmap |
||||||||||||||||
