Customizing Charts in VBA

[dan03uk]

I was wondering if there is away of creating a code using VBA that would exclude data when it has a value of 0 from the graph. This is because I have an ever changing set of data but values of 0 are not needed for the scatter graph.

 

[Sal Paradise]

Any reason you can't just make a formula =IF(A1=0,NA(),A1) and then plot those values instead? NA() won't plot, and that will solve your problem without a macro.

 

[dave3009]

Hi Dan

Welcome to the Board

If the new range doesn't suit hit the old one with a macro

Sub Clear0s()
Dim my, c As Range
Set my = ActiveSheet.Range("A1:H80")
For Each c In my
    If c.Value = 0 Then c.FormulaR1C1 = "=NA()"
Next c
End Sub

You'll need to be adjusting the ranges and that but it should fair you well

All the best


Dave

 

[dan03uk]

Hi,

Thankyou both for your help. I will test these out now.