June 20, 2008, 10:58 AM
fex08Displaying negative number data in bar graphs
I am showing negative number data on my horizontal bar graph and our standards are to display negative numbers with brackets instead of (-) minus signs. My data is formatted as D5B but the graph defaults to the minus sign.
June 20, 2008, 11:31 AM
mgrackinUsing DataTextFormatPattern should do it for you. However, I cannot find a good example that demonstrates how to use it. Check with IB for assistance.
June 20, 2008, 11:31 AM
fex08The following commands seem to manipulate the formatting of my data on the bars but I still do not know how to force the negative sign to be a bracket.
setDisplay(getDataText(),true);
setDataTextFormat(-1);
setDataTextFormatPattern("##");
June 20, 2008, 11:39 AM
mgrackinI'm taking a wild guess here but try changing the pattern to "##;[##]". I honestly have no idea if this will work.
setDataTextFormatPattern("##;[##]");
June 20, 2008, 12:26 PM
fex08Worked perfectly. Thank You!