G

#### Guest

data for 52 weeks, and set up as a combo box chart. Currently I have data for

only 16 weeks, while the rest of the year is howing zero values. I changed

the zero to #N/A to avoid plotting that on the graph, which worked fine, but

the issue is the X axis. I have tried 2 options but neither produced what I

needed.

* I have used a formula to show the weeks as N/A if no data available on the

next column.

** I used the OFFSET formula to creat a range, but both options plotted the

#N/A on the X axis. How can I incorportate a range successfully in another

OFFSET formula (combo box with dropdown list) to plot only the cells with

data. Any help is greatly appreciated.