Jon,
First my list is populated from another report list on the same sheet. My
chart list is as follow:
Weeks on column B (B66:B117) while my heading/labels start from C65 to N65.
I have this formula on O65 =OFFSET(B65, 0,$S$64) S64 is my link cell. On
C66 I have this formula =IF(D7=0,NA(),D7) and copied down C66:N117 this
formula basically looks the above report list and populate the data while
substitute any zero values with #N/A. Up to this point my chart is fine and
the combobox is working fine. Currently my list is showing actual data up to
week 16 and #N/A thereafter.
Here's the formual i'm trying to use to help plot only the data and ignores
#N/A which currently it didn't
=OFFSET('Model'!$B$66,0,0,COUNTA('Model'!$B:$B,-65),1), I have similar
formula based on the values on column O, as my 'Y' axis values. Model is my
sheet where the report list chart list and the chart reside.


Thanks.
--
when u change the way u look @ things, the things u look at change.


"Jon Peltier" wrote:

It would help to see your formulas.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"sahafi" wrote in message
...
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.