How to customize the ''No Data to Display'' error message.....

[#1]

Hi,

I need to customize ''No data to display'' error message on my bar chart for no data available for current selection.So how can i change this error message ...Please any body help me on this.

Thanks,

Vasudha

[salto]

Hi,

in the General tab of the properties of the bar chart, there is a button in the bottom left named "Error messages" where you can  customize the error messages shown in the chart.

Hope this helps!

[NZFei]

Making the change in "Error message" does not change the text for "No data to display".

It is impossible to change "No data to display" according to my know.

[#4]

Fei is right, the message cannot be changed. BUT fortunately you could produce a "calculation condition not fulfilled" condition which error message could be customized. E.g. I add the expression directly in the calculation condition. When it returns null, the condition is not fulfilled and I could make use of the custom error message box.

[#5]

Hi,

You can use a text box with your message to hide your graph when data is null.

Make a copy of bar graph in different sheet and convert that chart type from General tab to Straight Table.

After then you can use macro for this table (say CH16😞

Sub Msg

set cell=ActiveDocument.GetSheetObject("CH16").GetCell(1,4)

ActiveDocument.Variables("v").SetContent cell.text, True

set cell=nothing

End Sub

This will store the total (which is 0 whenever "no data to display" comes) of your expression in variable "v".Then you can use this v variable to show/hide your text box.

Hope this helps

Thanks!

[NZFei]

Will this automatically give the total number to the variable v? It looks to me that we still need to set up a button to run the micro.

Cheers.

Fei

[#7]

Yes, you have to make some button to run macro. But to run this automatically on the basis of user selection , apply triggers (to Run macro) on all columns through which data of that table (CH16) changes.

Note: in my table cell(1,4) contains total. For getting this value , check "Expression total" instead of "No Total" under expression tab

thanks!