charting your data automatically

A

amrezzat

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 matte
 
R

rsenn

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Possible? Variable X and Y data sources and Auto Charting 0
chart your data automatically 1
Pie Charts 1
Maybe too hard to do? 2
finding and summing data in somewhat complex matrix. 7
Excel Chart Problem!!! (Bug I think) 2
Creating a dynamic chart range where the range to be graphed depends on the contents of a cell 0
Too hard to do? 1

Top