Figure D The people chart is based on the survey data in the Table. How to customize Excel’s people chart The original settings are adequate, but you might want to customize the chart a bit.

You can make a bar graph in Excel by first selecting the range you want to depict, and then using the dropdown menu to select the desired chart.

How to Change the Color Coding on a Microsoft Excel Graph Legend. Color can make it easier for people to identify important information, such as legends on an Excel graph.