Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rsenn
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I fill data in a list automatically? KFuda Excel Discussion (Misc queries) 1 November 4th 05 06:36 PM
Master worksheet automatically enters data into sub worksheets Ken Excel Discussion (Misc queries) 1 November 1st 05 10:36 PM
Charting Filtered Data BCullenward Charts and Charting in Excel 1 October 27th 05 11:19 AM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 05:55 PM
Automatically pull data into another worksheet within the same fil TJess Excel Worksheet Functions 1 November 15th 04 08:00 PM


All times are GMT +1. The time now is 01:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"