Thread
:
How to switch off warnings for logarithmic axis in charts?
View Single Post
#
2
Posted to microsoft.public.excel.charting
Tushar Mehta[_3_]
external usenet poster
Posts: 37
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.
Reply With Quote
Tushar Mehta[_3_]
View Public Profile
Find all posts by Tushar Mehta[_3_]