Microsoft Excel is a spreadsheet program that allows you to manipulate, store and display your data. One method for displaying data is through a variety of graphs Excel allows you to create. There are a number of ways to customize these graphs to make them more attractive and relevant to your presentations. One such way is by changing the color coding of your graph and thereby its legend.
Select the segment of your Excel graph that you wish to change the color of.
Right-click on the segment of the Excel graph, and select "Format Data Point" from the menu that appears.
Ensure "Fill" is the highlighted option in the menu to the left of the dialog box that appears. Click the box next to Color that says "Automatic."
Select the color of your choice, and click "OK".
Tips & Warnings
- Different versions of Excel may feature slightly different menu set-ups. Visit the Microsoft website for version-specific instructions if you are struggling to change your settings.
- Photo Credit Jetta Productions/Lifesize/Getty Images
How to Make a Thermometer Chart in Microsoft Excel
The basic function of Microsoft Excel is to create efficient spreadsheets, but the application also allows users to make charts and graphs...
How to Sort Excel Spreadsheets by Color
Microsoft Excel provides the ability to shade or color cells in a spreadsheet. Some users apply color to represent values. An example...