Question: how to create a chart with both percentage and value in excel?
Answer: Select values placed in range B3:C6 and Insert a 2D Clustered Column Chart (Go to Insert Tab >> Column >> 2D Clustered Column Chart). ...  In cell E3, type =C3*1.15 and paste the formula down till E6. ...  In cell F3, type the following formula and paste the formula down till F6. ...  Select Chart and click on "Select Data" button.