This subject comes up whether you are doing a Pie Chart, a Bar Chart or a Line Chart. There is a good chance that the data on the Chart will be broken down in percentages.
For example, the percentage of lawyers to paralegal to non legal staff. Another example would be the percentage of 14 year olds with Cell Phones.
Pie Charts:
When we do Pie Charts, we can turn our Data Labels on each slice of the Pie to Percentages (For Example 20%, 40% ).
So, in order to show percentages in Pie Charts do the following:
1. Clicking on one Data Label will select all the Data Labels on the Pie Chart.
2. Right Click and go to Format Dara Labels.
3. Under Label Options, instead of the selection Value, which will show only a number such as "40" instead of 40% choose "Percentage" which will now place the Percentage Symbol" next to each Data Amount (Data Label) on each piece of the Pie.
Use of Percentage on Bar and Line Charts:
When doing Bar Charts and Line Charts the "Percentage" selection is not available so we need to customize the Data Labels in Order to have them show as a Percentage.
So, if we have values in our Bar or Line Chart such as 20, 40, 60 etc. and wish to change them to read as a Percentage, you would do the following:
1. Click on a Particular Data Series and "ALL" Data Values will now be selected in that Series.
2. Right click and choose "Format Data Labels".
3. Go to "Number" and go to "Custom".
4. Under "Format Code" put in ##\% followed by pressing the "Add" button.
5. The Data in that Particular Data Series will now show the number as a percentage. (40%)
6. If the number is initially using a decimal such as 12.4, 2.6, 10.2 then use ##.#\%.
Training From An Inside Perspective:
www.advanceto.com
No comments:
Post a Comment