I have a pivot chart with weeks on the Category Axis. If I select weeks 24,25,26 and 27 but there is only data for 24 and 26 (these are then shown on the graph) how do I show that the others have no data in them I need them to be shown on the chart as it is problems that I am reporting and weeks with no data are very important.