ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Disabling warnings on log axes (https://www.excelbanter.com/charts-charting-excel/223656-disabling-warnings-log-axes.html)

Graham Clarke

Disabling warnings on log axes
 
Is there any way to disable the warning that negative numbers cannot be
plotted on logarithmic axes? I am generating data and plotting
automatically usiong VBA and so the fix can either be an overall Excel
option or a VBA command.

Thanks in advance

Graham Clarke


Graham Clarke

Disabling warnings on log axes
 
I've found what I was looking for

VBA version - Application.DisplayAlerts = False




"Graham Clarke" wrote in message
...
Is there any way to disable the warning that negative numbers cannot be
plotted on logarithmic axes? I am generating data and plotting
automatically usiong VBA and so the fix can either be an overall Excel
option or a VBA command.

Thanks in advance

Graham Clarke





All times are GMT +1. The time now is 01:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com