Add more options for custom number formatting for chart axis or allow for conditional formatting there
This issue I have is that I have numbers ranging from -20 million to 20 million displayed on a chart. I am using custom number formatting for the chart Y axis to display thousands with "K" and millions with "M". This can only be done to apply to the positive numbers. I've tried to format my chart data with conditional formatting to the required format and then select "linked to source" in the number formatting selection under format axis, but it doesn't seem to work. The research I've done only has lead to many sources saying what I need cannot be achieved. It seems like a very simple problem and should not be this difficult. Please give more flexibility with the format code for chart axis or allow for conditional number formatting on chart axis.