Question: how to create a chart in excel with percentage?
Answer: Select the data labels and data. In this case, you'd select A1:D5. Then, click the Chart Wizard on the Standard toolbar. Choose Bar as the Chart Type, click the Stacked Bar subtype, and click Next. For this chart, choose Rows as the series source and click Finish.