Intelligent number formatting in chart axes
Add functionality to automatically adjust x and y axis number formatting to be appropriate to the min and max scaling. This would be particularly useful when the same chart template for dynamic charting and/or running scenarios.
For example in the following min/max ranges Excel could apply the following number formats:
0 to 10's - 0.0 (e.g. 5.0)
0 to 000's - #,##0 (e.g. 5,000)
0 to 000'000's - display units millions (e.g. 5.0 and add million label next to chart)
Thanks for the feedback. This is functionality that we are in the process of designing right now.
Oh, and along the lines of labeling axes, we should be able to stagger category axis so the labels can be horizontal and readable.
We should also be able to control 2-level (multi-level) category axes more easily.
We should be able to start a histogram category axis at a specific number without having to add dummy data to fake it.
We should have options to deal with various common scenarios for labeling charts and axes without resorting to complex number formatting.
For example, if my axis ranges to 2,000,000, I should be able to format the labels below 100,000 with a K (as 500K) and the labels >= 1 million with an M (as 1M, 2M, etc). Basically we're asking for [>=1000000] #,##0,,"M";[<1000000] #,##0,"K"; to be a standard option. This should of course be an option for billions and trillions as well. I know we have display units, but they don't give a mix of labels such as M and K. Instead, those change my 500K to .5M (and then only after I've adjusted the decimal places), which is not what I want. We also need these options for data labels, not just axes. (In fact, we don't even have display units options for data labels.)
It should also be a matter of one click to add identifiers such as currency symbols ($), percentages (%), units, M/K, etc., to the labels. The standard ones should be a dropdown or selection of some sort with an option for custom where we can input our own identifier. These should be treated as text and not affect the underlying data. They are just for labeling purposes, you know?
Add to this the option to label only the first label on the axis. [=2000]$#,##0;#,##0 for example.
We should be able to change colors for axis labels easily. We can do this now with number formatting. Why isn't this just an easy selectable option? #[Red][<500]0;[Black][>=500]0 for example.
Decimal places should be smarter. If I add currency, chances are I don't need decimal places. Why is the default 2 decimal places? Sure, this is probably the case in the cells, but not on axis labels, and more than likely not on data labels, either. So why is 2 decimal places the default for those?
Decimal places as described in the original post should also be easy to apply.
Users should not have to jump through number formatting hoops to make these things happen.