Groups

    EXCEL HELP PLEASE!

    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

    4 Comments

    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" 14th Mar 2011

    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

    Original Poster

    Thanks guys...will try that tonight and let you know how I get on! Many thanks

    27bslash6.com/p2p…tml

    A little off topic but still piechart related

    Edited by: "JIMMYRIDDLE77" 15th Mar 2011
    Post a comment
    Avatar
    @
      Text
      Top Discussions
      1. Win a luxury five-star break for two in Paris with Le Bristol Paris and Eur…67
      2. Win a Davosa Ternos Submariner Wristwatch worth £64545
      3. Win a flagship smartphone - the HTC U1134
      4. Magazine competitions - Issue 39 @ tvchoicemagazine.co.uk66

      See more discussions