How to create a Bar or Circle Progress Chart in Excel
A Chart is a graphical representation of data, such equally a pie chart, bar graph, line graph, etc. Charts can make the data interesting, highly-seasoned, and piece of cake to read for your audience.
What is a Progress Chart?
A Progress Chart is a graphical representation of the caste of completion of work in progress. Progress charts help individuals to monitor their objectives and provide disquisitional data for strategic decision-making.
How to Create a Progress Nautical chart in Excel
Follow the tutorial below to create a Progress Chart in Excel.
How to Make a Progress Bar Chart in Excel
Follow the steps to create a Progress Bar Chart:
Launch Excel.
Enter some information on your spreadsheet or use existing information.
Highlight the information range.
Click the Insert tab.
Click the Insert Cavalcade or Bar Chart push button in the Charts group and select the Clustered Bar nether the 2-D Bar from the menu.
The Clustered Bar will appear on the spreadsheet.
Click the Switch the Rows/Column button to place the Product column in the tabular array on the vertical centrality.
The Product column volition switch to the vertical axis, and the other columns will switch to the legend entry on the chart.
Correct-click the Target information series and choose Format Information Serial from the context bill of fare.
A Format Data Serial pane will appear on the right.
Click the Fill and Line tab.
Click Fill, so click No Fill.
Click Border and select Solid Line.
Then choose a colour for the edge of the no-filled bar.
Close the Format Data Series pane.
Click the nautical chart plot area and then click the Pattern nautical chart tab.
Then, click the Add Chart Element button, hover the cursor over Data Labels, and select Inside Base.
All the data serial is inserted into the bar chart.
Delete all data labels inside the bar chart's bar except the per centum.
Right-click the Target data series over again, and choose Format data series from the context carte du jour.
Nether Series, options set up the Series Overlap to 100%.
Click the horizontal (value) axis.
On the Format Data Series pane on the right, click the Centrality Options button.
Ready the Maximum target value for your chart in the Maximum entry box.
Close the Format Data Series pane.
Now nosotros have a Progress Bar Chart.
How to brand a Progress Circumvolve Chart in Excel
Launch Excel.
Enter some data on your spreadsheet or use existing data.
Highlight the data range.
Click the Insert tab.
Click the Insert Pie or Doughnut chart push in the Charts group and select Dougnut from the driblet-down menu.
Now we are going to resize the doughnut chart hole size.
Double click any of the doughnut slices; for case, we will double series 1 point i.
The Format Data Point pane will appear on the right.
On the Series Options tab, under Series options, set the Dougnut hole size to sixty%.
Now we are going to recolor the slices of the doughnut chart.
Still, on the serial i indicate 1 slice, click the Make full and Line tab on the Format Data Point pane.
Under Fill up, click Solid Fill.
Then cull a color.
Set up the Transparency to 30%.
On the chart, double click the serial 1 indicate 2 slice to customize the series i point 2.
Yet, on the Fill and Line tab, click Make full, and so click Solid Fill.
Choose a color.
Click the plot area on the nautical chart, and so click a slice to select both series 1 betoken 1 and series one signal 2.
Then click the series 1 point 1 slice and select the Fill and Line tab on the Format Information Series pane.
Click Border, select Solid line, and cull a color.
Also, under Edge, set the width to 2pt.
Close the Format Data Series pane.
Now, we volition add a textbox to the nautical chart.
Click the Insert tab.
Click Text and select a text box.
Draw the text in the hole of the doughnut circle.
Type = A2 into the formula bar and press enter.
Conform the size, weight, manner to your taste.
Delete the legend entry.
Now, we have a progress circle.
Read: How to create a Half Pie Nautical chart in Excel.
We hope this tutorial helps you empathise how to create a progress chart in Microsoft Excel; if yous have questions about the tutorial, let us know in the comments.
Source: https://www.thewindowsclub.com/how-to-create-a-bar-or-circle-progress-chart-in-excel
Posted by: cappsutonce42.blogspot.com
0 Response to "How to create a Bar or Circle Progress Chart in Excel"
Post a Comment