See attached. Negative bars simply do not plot. I did force the Static Min in the Axes tab to -50 to show this.
Is this a bug?
Can you post a sample?
or can you check the format?
I can see from the screenshot that negative numbers are left aligned - this shows that they are recognized as text and not numbers - would explain why they are not showing up in the bar chart.
Looks like formatting problem in your profit calculation.
Can you post your sample apps or file?
If the load script itself is loading negative numbers in brackets like (10) instead of -10. It will be recognised as text only.
Good catch - that was it! I changed the ($3.00) to -3.00 and it's working. I also added 'as Value' to the load script.
Thanks to all who posted.
Please close the thread by selecting correct or helpful answer.
Retrieving data ...