ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How to switch off warnings for logarithmic axis in charts? (https://www.excelbanter.com/charts-charting-excel/160833-how-switch-off-warnings-logarithmic-axis-charts.html)

parapluie

How to switch off warnings for logarithmic axis in charts?
 
Often one has to use logarthmic charts on data which may change, or will be
typed in later. Usally a warning message pops up, whenever the sheet is
calculated. This keeps the user busy even in cases where this diagram is not
used.

Tushar Mehta[_3_]

How to switch off warnings for logarithmic axis in charts?
 
In article ,
says...
Often one has to use logarthmic charts on data which may change, or will be
typed in later. Usally a warning message pops up, whenever the sheet is
calculated. This keeps the user busy even in cases where this diagram is not
used.

I am not sure I understand what data you want to plot but consider
replacing all values <= 0 with NA(). If necessary, use an additional
column to contain the data to be plotted. That way your computations
can continue to use the original data and the chart can use the new
data.


All times are GMT +1. The time now is 05:57 AM.

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