Excel Chart - Supress Zero Values 1

[hjgoldstein]

Hi all.

I have a column chart I need to create.

The data are:

[tt]Balloon Total NBV End Date
5,093.63 5,785.33 Apr-2011
5,425.72 6,176.40 Apr-2011
6,183.68 6,985.84 Apr-2011
6,731.25 7,534.22 Apr-2011
12,497.74 14,477.35 Apr-2011
7,658.40 8,498.51 Apr-2011
5,902.31 6,692.60 Apr-2011
7,898.72 8,694.61 Feb-2011
5,902.31 6,691.79 Apr-2011
5,784.19 6,490.20 Apr-2011
10,351.69 11,782.58 Apr-2011
4,974.14 6,065.33 May-2011
5,902.31 6,894.91 May-2011
3,905.20 4,858.48 May-2011
3,833.71 4,693.48 May-2011
6,786.40 7,856.50 May-2011
3,833.71 4,689.59 May-2011
4,974.14 6,063.09 May-2011
8,913.04 17,634.95 Oct-2012
5,838.04 10,182.08 Oct-2012
3,052.72 7,892.00 Oct-2012
5,771.20 10,147.44 Oct-2012
5,838.04 10,155.60 Oct-2012
5,771.20 10,348.09 Nov-2012
4,701.63 10,580.10 Nov-2012
5,949.46 10,406.20 Nov-2012
6,038.59 12,197.64 Nov-2012
5,258.70 11,279.98 Nov-2012
5,838.04 10,357.86 Nov-2012
9,158.15 18,042.23 Nov-2012
5,704.35 12,406.71 Dec-2012
5,704.35 12,406.71 Dec-2012
5,258.70 11,526.76 Dec-2012
5,258.70 11,526.76 Dec-2012
5,258.70 11,526.76 Dec-2012
5,258.70 11,526.76 Dec-2012
5,258.70 11,526.76 Dec-2012
13,770.65 25,732.37 Dec-2012
3,402.13 8,400.85 Dec-2012[/tt]

As you can see, there are no values between May-11 and Oct-12.

Is there a way of excluding the zero calued months from the chart? It would look much better without big gaps in between the columns.

It is time for pacifists to stand up and fight for their beliefs.

 

[SkipVought]

Hi,

Make your X axis a CATEGORY axis rather than a Date/Time axis.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[hjgoldstein]

Thanks Skip!

It is time for pacifists to stand up and fight for their beliefs.