Custom Graph Axis (Color issue)

[danrosey]

I have a custom Format Cost for some Y Axis values written as follows:

[>=1000000] $#,##0.0,,"M";[>0] $#,##0.0,"K"


For some reason, the first value shown (where X/Y axis meet) is displaying in a random color. Even if I format the whole axis to one color or another, it just formats the first value to some other random color. I just need the axis values to be black.


Any help welcome!

 

[danrosey]

Figured it out...needed to finish up the formatting.


[>=1000000] $#,##0.0,,"M";[>0] $#,##0.0,"K";0

 

[Luke M]

Cool, thanks for posting back w/ the solution!