charting your data automatically
heloo guys suppose i have a sheet like this (4 column) 1 intel 30 30% 2 microsoft 20 20% 3 att 10 10% 4 bell 20 20% 5 sony 10 10% 6 lg 10 10% as the forth colum is the percentage of every company over the total 30%= 30/(30+20+10+20+10+10) and every time you open the sheet you may add some data How you can chart that data automatically ? as a pie as each company percentage will be a piece in the pie chart please answer me in details.... note i allready calculated the percentage... i want the charting matter -- amrezzat ------------------------------------------------------------------------ amrezzat's Profile: http://www.excelforum.com/member.php...o&userid=28766 View this thread: http://www.excelforum.com/showthread...hreadid=488228 |
charting your data automatically
Make sure the Standard Toolbar is visible (View Toolbars Standard). Find the Chart Wizard button. It looks like a colorful graph. Follow the instructions of the Chart Wizard. -- rsenn ------------------------------------------------------------------------ rsenn's Profile: http://www.excelforum.com/member.php...o&userid=29050 View this thread: http://www.excelforum.com/showthread...hreadid=488228 |
All times are GMT +1. The time now is 07:38 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com