We're aware that some users are experiencing technical issues which the team are working to resolve. See the Community Noticeboard for more info. Thank you for your patience.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!

Excel - how to create income and outcome pie chart?

Options
CLLC
CLLC Posts: 1,041 Forumite
Part of the Furniture Combo Breaker
Hi MSE's :hello:

I've totally forget from my high school days how to create pie charts. Basically I'm trying to list all my incomings, outgoings and then put it in a easy to read pie chart.

However, I don't know where to put the appropriate sections on the grid as when i highlight them and then select the pie chart doesn't read it. Can anyone show me an example?

On the grid it's basically got to have incomings, outgoings, and somewhere i can put a small description. I.e Income - wage. Outgoing - sainsburys.

Thanks!
:dance: I am great , yes I am :dance:
:rotfl:
:D If you think I was useful , Thank you, for thanking me :D

Comments

  • Lokolo
    Lokolo Posts: 20,861 Forumite
    Part of the Furniture 10,000 Posts
    Highlight the numbers and the options

    So like:

    Car | £100
    Rent | £500
    Food | £600

    then click chart, then click Pie Chart....


    Don't do it like

    Rent | £100
    Sainsburys | £6
    Sainsburys | £10
    Car | £20
    Car | £25

    ( | indicates a new cell )
  • Lokolo
    Lokolo Posts: 20,861 Forumite
    Part of the Furniture 10,000 Posts
    piechart.png

    Example of how I just did one :)
  • Lil306
    Lil306 Posts: 1,692 Forumite
    Part of the Furniture 1,000 Posts Name Dropper Combo Breaker
    Lazy way of creating a simple chart is also highlight data and press F11 on keyboard IIRC :D
    Owner of andrewhope.co.uk, hate cars and love them

    Working towards DFD

    HSBC Credit Card - £2700 / £7500
    AA Loans - (cleared £9700)
This discussion has been closed.
Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

Categories

  • All Categories
  • 350.7K Banking & Borrowing
  • 253K Reduce Debt & Boost Income
  • 453.4K Spending & Discounts
  • 243.7K Work, Benefits & Business
  • 598.5K Mortgages, Homes & Bills
  • 176.8K Life & Family
  • 256.9K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16.1K Discuss & Feedback
  • 37.6K Read-Only Boards

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.