View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
amrezzat
 
Posts: n/a
Default 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