impcymru / impcymru-chart-formatter

A VBA module for automatically formatting various charts in Excel
0 stars 1 forks source link

Autoformat numerical y-axis #3

Open impcymru-adam-watkins opened 2 years ago

impcymru-adam-watkins commented 2 years ago

At the moment it tries to auto-format percentage and date axis, but doesn't try to handle simple numbers.

Considerations:

impcymru-adam-watkins commented 2 years ago

Ideally y-axis tick markers would include units where appropriate. At a minimum, the auto-formatting should retain these where they're part of the existing number format. (Note that units can be leading - e.g. "£" - as well as trailing - e.g. "cm".)

impcymru-adam-watkins commented 2 years ago

The Health Care Data Guide suggests:

Most of the data lies in about the middle half of the graph.