Charts<\/strong> are the most useful tool. We will present the charts and show you how can you add percentages to them in the example below.<\/p>\n\n\n\nCreate Chart from Data<\/h2>\n\n\n\n For our example, we will use the table with NBA players and their statistics from several categories: points, rebounds, assists, and turnovers:<\/p>\n\n\n\n <\/figure>\n\n\n\nTo create a basic bar chart out of our range, we will select the range A1:E8<\/strong> and go to Insert tab >> Charts >> Bar Chart:<\/strong><\/p>\n\n\n\n <\/figure>\n\n\n\nWhen we hover around this icon, we will be presented with a preview of our bar chart:<\/p>\n\n\n\n <\/figure>\n\n\n\nWe will select a 2-D Column<\/strong> and our chart will be created:<\/p>\n\n\n\n <\/figure>\n\n\n\nAdd Percentages to the Bar Chart<\/h2>\n\n\n\n If we would like to add percentages to our bar chart, we would need to have percentages in the table in the first place. We will create a column right to the column points in which we would divide the points of each player with the total points of all players.<\/p>\n\n\n\n
Our table will look like this:<\/p>\n\n\n\n <\/figure>\n\n\n\nWe will select range A1:C8<\/strong> and go to Insert >> Charts >> 2-D Column >> Stacked Column<\/strong>:<\/p>\n\n\n\n <\/figure>\n\n\n\nOnce we do this we will click on our created Chart<\/strong>, then go to Chart Design >> Add Chart Element >> Data Labels >> Inside Base<\/strong>:<\/p>\n\n\n\n <\/figure>\n\n\n\nOur chart will look like this:<\/p>\n\n\n\n <\/figure>\n\n\n\nTo lose the colors that we have on points percentage and to lose it in the title we will simply click anywhere on the small orange bars and then go to Format >> Shape Styles >> Shape Fill >> No Fill<\/strong>:<\/p>\n\n\n\n <\/figure>\n\n\n\nThen we will click on the points percentage text in our bar chart and delete it:<\/p>\n\n\n\n <\/figure>\n\n\n\nNow our bar chart looks like this:<\/p>\n\n\n\n <\/figure>\n\n\n\nClustered Column<\/h2>\n\n\n\n It has to be noted that the easier and probably more convenient way to present this kind of data would be if we simply chose Clustered Column<\/strong> as our Chart type<\/strong>.<\/p>\n\n\n\nTo do this, we will select our range again and then go to Recommended Charts<\/strong> in the Insert tab<\/strong>. When we click on it, Clustered Column<\/strong> will be the first option for us:<\/p>\n\n\n\n <\/figure>\n\n\n\nWe will click OK<\/strong> and will have the chart that looks more natural for the thing that we want to present:<\/p>\n\n\n\n <\/figure>\n","protected":false},"excerpt":{"rendered":"Excel is not only a useful tool for calculations but rather can be an awesome tool for presenting data graphically. To show our…<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[170,190],"yoast_head":"\n
Add Percentages to Excel Bar Chart<\/title>\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n\t \n\t \n\t \n