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.
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.