EXCEL HELP PLEASE! - HotUKDeals
We use cookie files to improve site functionality and personalisation. By continuing to use HotUKDeals, you accept our cookie and privacy policy.
Get the HotUKDeals app free at Google Play

Search Error

An error occurred when searching, please try again!

Login / Sign UpSubmit

EXCEL HELP PLEASE!

£0.00 @
Hi, I need to make a pie chart made up from the cost of 3 items (ticket price, transport, wages) and I have to use Excel to do it and I'm struggling big time. Have an Excel book but I can't get i… Read More
luvvlychocolate Avatar
6y, 3m agoPosted 6 years, 3 months ago
Hi, I need to make a pie chart made up from the cost of 3 items (ticket price, transport, wages) and I have to use Excel to do it and I'm struggling big time.

Have an Excel book but I can't get it to make a pie chart....problem seems to be with the monetary amounts.

If anyone can point me to a website that can hel...I'd appreciate it greatly
luvvlychocolate Avatar
6y, 3m agoPosted 6 years, 3 months ago
Options

All Comments

(4) Jump to unreadPost a comment
Comments/page:
#1
in cells

a1=(heading)item name
a2=price
a3=transport
a4=wages

b1=(heading)price of item
b2= £1
b3=£2
b4=£3

highlight a1:b4

go to insert

chart > pie > finish

does it look right?

Edited By: greg_68 on Mar 14, 2011 21:25
#2
Just highlight your data, which should be in the form of a table as below. The numbers should be in a different column to the words. Click the chart button, select pie for type and hit finish. Piece of cake. If you're having a problem with the currency, just use numbers (i.e. no currency symbols) as the point of a pie chart is to show the ratio, not the amount.

e.g.
ticket 6
transport 8
wages 5

Bit like Greg_68 says but without the headings
#3
Thanks guys...will try that tonight and let you know how I get on! Many thanks :)
#4
http://www.27bslash6.com/p2p2.html

A little off topic but still piechart related :p


Edited By: JIMMYRIDDLE77 on Mar 15, 2011 11:28

Post a Comment

You don't need an account to leave a comment. Just enter your email address. We'll keep it private.

...OR log in with your social account

...OR comment using your social account

Thanks for your comment! Keep it up!
We just need to have a quick look and it will be live soon.
The community is happy to hear your opinion! Keep contributing!