I have a bunch of charts on my dashboard (Dashboards 4.1 for the record). As I’m finishing up development, I notice that they are now only displaying the top value on each y-axis. They are auto-scaling properly. They are using the fixed labeling properly. The only problem is that they aren’t showing the values.
Now, I think the problem is that I applied a custom format to the numbers in the table. I think this is throwing something off. But I need that custom format.
First, it is definitely an issue with the custom format. Based on customer requirements, zero values should simply not be displayed. Easily done with the custom format.
For reasons I don’t entirely understand, if one end of the axis is blank, all the intermediate axis labels are also blank. So if I used manual scaling to make the lower end -1 instead of 0 (or, with currency, $0.01), the labels would appear. And the custom format of the values is automatically applied to the axis labels. (Oddly, the format options exist at the label level, but are disabled, and I haven’t found any way to enable them.)
One thing I did discover is that the format of the first series is what is applied to the axis labels. Even if that series does not actually appear on the chart. I was able to use this (thanks to a peculiarity of my data) to resolve my issue.
(BOB member since 2005-01-28)