Hi,

You need to set up some dynamic named ranges. More details here
http://peltiertech.com/Excel/Charts/Dynamics.html

Cheers
Andy

Jerome wrote:
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? Is this possible?

Thanks.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info