How to Change the Color Coding on a Microsoft Excel Graph Legend


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.

Related Searches


  • Photo Credit Jetta Productions/Lifesize/Getty Images
Promoted By Zergnet


You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!