Disabling Error Message about -ve or Zero values on Log Charts

[Kristian]

I have a log chart with all +ve values, (small values are
included) but it has some zero values so of course Excel
gives me a message. It's a Dynamic Chart Range so I don't
want to change the range manually everytime.

I know there is a way to use Pivot Tables to make the
Chart Range Dynamic, but isn't there some way of just
disabling this message?

Kristian

 

[Tushar Mehta]

Unfortunately -- or is it fortunately? -- the answer is no. However,
have you considered having the chart adjust to the actual data? For
examples that you can adapt to your specific case, see the Excel |
Tutorials | 'Dynamic Charts' page of my web site.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions