how do I set up or adjust my column chart?
 

I am creating a shipping schedule template and have 9 weeks that I ship
products. I would like to show each customer how many units they receive per
week.

My template is set up for 9 ship weeks. Here is an example for 3 shipments.
0 means no product is being shipped.
Row 1: Oct 6, Oct 13, Oct 20, 0,0,0,0,0,0 (total 9 weeks)
Row 2: 233, 545, 102, 0,0,0,0,0,0 (number of units shipped that week)

Now most of my customers only receive 2 or 3 shipments and only a few take
as many a 8 or 9 shipments.
How can I set up a column chart so that I only see 3 columns when I ship 3
weeks and not all 9 weeks where only the first 3 weeks show a value and the
other weeks are all 0?

Thanks.