how do I set up or adjust my column chart?

[Jerome]

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]

Hi,

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

Cheers
Andy

 

[Tushar Mehta (Microsoft MVP Excel 2000-2008)]

Especially if there are no shipments after a bunch of zeros, adapt the
ideas at
Dynamic Charts
http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/index.html

In particular, replace the references to COUNTA with COUNTIF and in
the OFFSET function, references to the number of rows to plot with
references to the number of columns to plot.