Replace the error_message for "no data"

[datanibbler]

Hi,

in one of my charts - possibly in others lateron - I'd like to display the standard_error_message "no data" with a custom message. The background is that I have a standard selection for that sheet:

>>> current_year, current_month <<<

<=> In that list, there is no data for the current month, so I get this message. One has to remove the month_selection to get it working.

Can someone help me there? I know that on the "general" tab of the properties_dialog you can set the error_messages, but that particular one is not there.

Thanks a lot!

Best regards,

DataNibbler

[bbi_mba_76]

Hi,

maybe there is a better solution, but you could use the calculation condition/show conditional to hide the chart and add a text box with your custom message.

[datanibbler]

Excellent idea, BBI_MBA_76,

there's just one issue: A textbox with the corresp. show_condition will then show up on every tab of that combobox, not only on the one where I have that "no data" issue.

I tried alternatively to use a free_text_box inside that diagram, but it seems that is not displayed when the diagram itself isn't displayed...

[Anonymous]

Nibbler

On the General tab of your Chart have you investigated the Error Messages button, when clicked it allows one to to set Custom Messages.

Best Regards,     Bill

[datanibbler]

Hi Bill,

yes, I have tried that.

However, you can set a nr. of messages there - but not that "no data to display"_message.

I think I'll try to tackle that in a different way, though, by simply manipulating the base file so that it has the value 0 in those months where there is no data yet - so I won't get that message to begin with.

I'll be back to debrief if it worked that way.

Excel, here I come...

Best regards,

DataNibbler

[datanibbler]

That worked fine. Now my standard_selections work for that diagram, too - albeit there's nothing to see, there are 0 whatchamacallits in the list for the current month - but at least there is no error message.

That issue is thus solved.

Best regards,

DataNibbler

[ThornOfCrowns]

What Bill is saying is that you can put your own wording into that custom message field and set a Calculation Condition to trigger it, so you don't need to mess about with the data.

Example:

Calculation Condition  =sum(if(IndicatorID='3',Data))>0 will show the custom message ( 'No Waits over 3 hours' )

[datanibbler]

Thanks James,

I understand quite well, I've seen that option and tried it out. The message of "no data to display" isn't there. I could do it otherwise, of course: I could set a condition for the formulas depending on the month_selection and then edit the message of "all formulas deactivated". Several roads lead to Rome...

Best regards,

DataNibbler