a tip on pivot charts

when plotting bar charts using pivot tables, it is little difficult to hide/delete unwanted rows:

for example the below pivot chart shows some data for years 2012 and 2013 spreading over months. But it is not important to show the data for future months - or other wise any month which is not important. If we try to delete a row for a month let us Jan or Feb of 2013, in pivot chart or table, Jan or Feb of 2012 will go out of the bar chart.

To get the correct representation, go to pivotTableOptions->Display-> select "Classic pivot table layout"

The table will be shown in expanded form with years and months. copy the pivot table data and paste into another sheet (only values). Delete the unwanted rows. and plot a bar chart . Then you will get like this: for example, i dont want to represent the data of Sep 2012, and March to Dec of 2013.

September 2012,, and March to Dec of 2013 are not shown in the above chart.

This is one easy way of getting bar chart when we wanted to show data with zero values.

I faced lot of issues to get this done, in the mean time i had to do some image manipulation. but this one is clean.