I have charts that are being created by xml created by a php script that pulls information from a database and does various calculations to output a final value that is represented in the chart. All works fine besides one annoying thing.
When there is no data available to calculate the value passed is blank (ie: empty, ) but the chart needle points to 100 or top of scale.
I cannot enter 0 because there are possibilities in a true zero value being calculated. I need some way of getting the chart to display "Insufficient Data" or "Error" or the like.
Is this possible?
Thank you in advance for time.