Exclude zero data columns on bar cahrt

[Bluekingcroft]

My spreadsheet is for calculating cash-flow during retirement, it asks a number of questions, one being "what year does pension start".
My spreadsheet works very well mathematically, but I would like to avoid the type of display as shown in the attached example.
How do I have the chart dynamically start at the correct year? in the case attached exclude everything until year 63.

I need the explanation in simple terms or an attached solution - PLEASE HELP !!!!

[jstawski]

This is a quick work-around. I wrote a macro that is used with the two buttons on the bottom of the graph. The macro will hide the cells containing a zero or blank value in column B. This is a choppy way of doing so because the macro selects each cell individually so you'll see the program hiding the cells. To make it so the workbook doesn't show the steps, turn screen-updating off in the code.


EDIT: Ignore Module1 in the code. Code was written for Sheet1

-J Stawski