Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

OK . . .

My question was oversimplifying the actual usage. The range for the graph is not just a numeric entry. It is a formula based on an entry in an adjacent column.

One way of handling "blank" values in the resulting range (the one to be graphed) is to use an IF statement for the formula to filter out the blank values.

For example, IF(A1 ="", "", (non-blank formula for the graphed column here))

That said, I think LO Calc graphing should be "smart" enough to enforce "blank" graphing rules even when the results come from a formula!

Additional wisdom is welcomed!

OK . . .

My question was oversimplifying the actual usage. The range for the graph is not just a numeric entry. It is a formula based on an entry in an adjacent column.

One way of handling "blank" values in the resulting range (the one to be graphed) is to use an IF statement for the formula to filter out the blank values.

For example, IF(A1 ="", = "", "", (non-blank formula for the graphed column goes here))

[ i.e.: if A1 is blank, display blank, else use the entered formula entered here for this cell)

That said, I think LO Calc graphing should be "smart" enough to enforce "blank" graphing rules even when the results come from a formula!

Additional wisdom is welcomed!

OK . . .

My question was oversimplifying the actual usage. The range for the graph is not just a numeric entry. It is a formula based on an entry in an adjacent column.

One way of handling "blank" values in the resulting range (the one to be graphed) is to use an IF statement for the formula to filter out the blank values.

For example, IF(A1 = "", "", (non-blank formula for the graphed column goes here))

[ i.e.: if A1 is blank, display blank, else use the entered formula entered here for this cell)

That said, I think LO Calc graphing should be "smart" enough to enforce "blank" graphing rules even when the results come from a formula!

Additional wisdom is welcomed!