VBA or Way to Ignore "Negative or Zero Values Cannot Be Plotted on a Logarithmic" scale

nc_waggoner

New Member
Joined
Sep 2, 2016
Messages
21
Good morning,

I have a sheet that has pivot charts connected to an analysis tab. The analysis tab converts qualitative data (<10) to numbers which are then charted on a Log-10 scale. Every time I refresh or use the Timeline slicer, the "Negative or Zero Values Cannot Be Plotted on a Logarithmic Scale" warning pops up. There are about 30 charts and it pops up the warning for each one...is there any way to eliminate this warning. I have tried embedding the Applications.Alerts = False (that's off memory and may be wrong) into the refresh macro and it DID work when refreshing, but the error still popped up when you move the timeline to a different date. Any input would be greatly appreciated.
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Forum statistics

Threads
1,223,889
Messages
6,175,224
Members
452,620
Latest member
dsubash

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top