It sounds like you are plotting a LINE chart. Can you change it to a
scatter chart?

"sahafi" wrote:

I have a dynamic line chart with 12 data series that each contains weekly
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.
--
when u change the way u look @ things, the things u look at change.