How do you handle missing values when using VBA excel? E.g. I have a amcro
that creates a chart. Sometimes there a values missing in the data for the
chart. How do you handle this? Is there a setting that you can change, if so
where? thanks!

create a chart. Select the chart, go into Tools=Options and select the
chart tab.

You will see some options for missing values. You can turn on the macro
recorder while you change them and see what code is recorded - this should
give you some insight in to the object and properties for these options.

--
Regards,
Tom Ogilvy


"Arne Hegefors" wrote:

How do you handle missing values when using VBA excel? E.g. I have a amcro
that creates a chart. Sometimes there a values missing in the data for the
chart. How do you handle this? Is there a setting that you can change, if so
where? thanks!