![]() ![]() Then, select the created chart, and right click, choose Select Data from the context menu, see screenshot:ĥ. And then, in the second helper column, Column E, enter this formula: =B2&CHAR(10)&" ("&TEXT(C2,"0%")&")", and drag the fill handle down to the cells that you want to use, see screenshot:Ĥ. After inserting the chart, then, you should insert two helper columns, in the first helper column-Column D, please enter this formula: =B2*1.15, and then drag the fill handle down to the cells, see screenshot:ģ. Select the data range that you want to create a chart but exclude the percentage column, and then click Insert > Insert Column or Bar Chart > 2-D Clustered Column Chart, see screenshot:Ģ. ![]() To solve this task in Excel, please do with the following step by step:ġ. It is easy for us to add percentage or value to the bar or column chart, but, have you ever tried to create a column or bar chart with both percentage and value displayed in Excel?Ĭreate a chart with both percentage and value in ExcelĬreate a stacked chart with percentage by using a powerful feature How to create a chart with both percentage and value in Excel? ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |