Header Ads


Select the cells with the Names and Values ​​in the worksheet, in your case they will be 6 cells, choose the insert menu and click on the type of graph you want and the graph will be created:

To display percentages, right click on the chart and from the drop down menu choose Format Data Labels , in the new window check the Percentage option and click the close button .

Excel bar charts

Other ways:
You can also use gantt chart excel for auto chart creation or to make things easier. Orelse scroll down and read the full process below. 

Select the data for which you want to create a chart.
Click INSERT > Recommended Charts.

On the Recommended Charts tab, scroll through the list of charts that Excel recommends for your data, and click any chart to see how your data will look.

If you don’t see a chart you like, click All Charts to see all the available chart types.

When you find the chart you like, click it > OK.

Use the Chart Elements, Chart Styles, and Chart Filters buttons, next to the upper-right corner of the chart to add chart elements like axis titles or data labels, customize the look of your chart, or change the data that is shown in the chart.

To access additional design and formatting features, click anywhere in the chart to add the CHART TOOLS to the ribbon, and then click the options you want on the DESIGN and FORMAT tabs.

No comments