Chart that will show the percentage on a photograph

Asked By clive walker 30 points N/A Posted on - 06/21/2012

 

I want to create a chart that will show the percentage on a photograph. Can it be done in MS-Excel? Or suggest me any substitute.

• Status: Open
• Question Views: 914
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Charlio sanhy

Go To Solution

Best Answer

Best Answer

Answered By Charlio sanhy 0 points N/A #154500

Chart that will show the percentage on a photograph

You can easily create chart that will show the percentage on a photograph using Ms Excel. I am telling you how can you easily create a chart on MS excel without. It’s very simple, just follow the instruction.

Step 1: select data want to make chart.

Step 2: Click on Chart Wizard button on the toolbar to open Chart Wizard

Step 3: When you open the wizard the column chart type is selected, you can easily choose another chart type. But column chart type is commonly used to compare items.

Step 4: Now click on finish button at the bottom of the wizard.

 

Your task is completed.

About Charlio sanhy

Questions
0

Answers
14

Best Answers
2

• Vote Up 0 Vote Down

• Posted on - 06/22/2012
• Question Category: MS Excel

Answered By Sherin Viluel 0 points N/A #154501

Chart that will show the percentage on a photograph

Yes, you are able to create a chart which will show the percentage.

First I will take as an example a table which includes data with that will show the percentages.

 

In Microsoft Excel you can create verity of charts which is suitable for a given situation.

Click on the insert tab. Then you can see some of chart type that we can use in charts option.

 

I am choosing “Pie” type of chart in this scenario.

First select the whole table except total row and click on the “Pie” chart type.

I will select first category under 2D-Pie section and click on that.

Then the pie chart will be shown.

In that pie chart right click on the circle and click on the Add data labels.

 

Then the values of each category sales will be shown as follows.

 

 

Now right click on the circle again and click on format data labels.

 

Then tick on the percentage check box and close the window.

 

 

Now you can see the percentage on the chart as you expect.

About Sherin Viluel

Questions
0

Answers
50

Best Answers
37

• Vote Up 0 Vote Down

• Posted on - 06/26/2012
• Question Category: MS Excel