On Thu, 25 Aug 2005 11:53:46 -0200, Alberto Monteiro
<[EMAIL PROTECTED]> wrote:
(1) is there any way to mix lines and columns in a graphic?
Don't understand the question.
(2) is there any intelligent way to plot only meaningful values? For
example, if I am plotting densities (A1:A10 is volume, B1:B10 is mass,
C1:C10 is density, but not all of them have decent values: B7:B10 or
maybe B8:B10 are zeroes), I would like to restrict the plot to numbers
that are
not zero/zero.
Write a macro that turns zeros into blank spaces in a column of data and
then go to tools/options/chart and plot empty cells as interpolated.
This macro creates a new column of data without the zeros:
Sub IgnoreZeros()
Application.ScreenUpdating = False
Do While ActiveCell <> ""
If ActiveCell <> 0 Then
CellValue = ActiveCell
ActiveCell.Offset(0, 1).Activate
ActiveCell = CellValue
ActiveCell.Offset(0, -1).Activate
End If
ActiveCell.Offset(1, 0).Activate
Loop
End Sub
Alberto "I hate M$ and all the crap it sells" Monteiro
Me too, but Excel is one of the things I hate the least.
--
Doug
_______________________________________________
http://www.mccmedia.com/mailman/listinfo/brin-l
