Change graph font to white

Av8tordude

Well-known Member
Joined
Oct 13, 2007
Messages
1,074
Office Version
  1. 2019
Platform
  1. Windows
In the image below, the positive number are white, but the negative numbers are red. How do I make both numbers on each side white font. What I tried is to right click the numbers to edit the font color, but the negative (red) numbers did not change to white.

1678152196386.png
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.
If you right-click on the cell/column, select "Format Cells" and go to the Number tab, which format is selected?

Note that there are 4 different options for "Currency". Choose one that does NOT show a red color.

1678193850078.png


If you have selected one that doesn't show the red color, but your values are still showing up as red, check your Conditional Formatting rules on that column.
Lastly, if neither of those things is true, check the Sheet for VBA code.
 
Upvote 1
Solution
Didn't consider the cell format, but also didn't think the graph would consider the cell format since it can be formatted in the graph. Thank you for the helpful advice.
 
Upvote 0
You are welcome.
Glad I was able to help!
 
Upvote 0

Forum statistics

Threads
1,214,832
Messages
6,121,841
Members
449,051
Latest member
excelquestion515

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top