Handle missing values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Placing charts 3
Macro to determine min/max values of column 3
Bubble Charts - Series and Bubbles Missing (sometimes) 2
Hiding 0 value data labels in chart 8
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
advanced filternot working in macro 1
Using =Offset in Charts 1
Why do charts disappear? 2

Back
Top