First time here? Check out the FAQ!

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!

2 | No.2 Revision |

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,

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!

3 | No.3 Revision |

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,

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!

Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.