Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I fill data in a list automatically? | Excel Discussion (Misc queries) | |||
Master worksheet automatically enters data into sub worksheets | Excel Discussion (Misc queries) | |||
Charting Filtered Data | Charts and Charting in Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Automatically pull data into another worksheet within the same fil | Excel Worksheet Functions |