Question: How do I customize the chart for the meaningful presentation
Answer: In Excel 2007 and above the charts can be easily customized with the command Format object (chart). This is a common window have the properties needs to be changed. In the below example the pie chart pan and pan explosion angle can be rotated by the properties window.
Copy paste the data in a excel sheet and select the data to insert the pie chart.
| Sl No. | Month | Sales |
| 1 | Dec/10 | 10000 |
| 2 | Jan/11 | 3000 |
| 3 | Feb/11 | 25000 |
| 4 | Mar/11 | 2300 |
| 5 | Apr/11 | 3400 |
| 6 | May/11 | 19000 |
| 7 | Jun/11 | 400 |
| 8 | Jul/11 | 4567 |
| 9 | Aug/11 | 6000 |
| 10 | Sep/11 | 6000 |
Right click the chart and select the format command. In the menu select your choice and customize the chart as required and give a professional look.
No comments:
Post a Comment