We'd like to remind Forumites to please avoid political debate on the Forum... Read More »
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
Posts: 1,041 Forumite

in Techie Stuff
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!
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:
If you think I was useful , Thank you, for thanking me
:rotfl:


0
Comments
-
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 )0 -
Example of how I just did one0 -
Lazy way of creating a simple chart is also highlight data and press F11 on keyboard IIRCOwner of andrewhope.co.uk, hate cars and love them
Working towards DFD
HSBC Credit Card - £2700 / £7500
AA Loans - (cleared £9700)0
This discussion has been closed.
Confirm your email address to Create Threads and Reply

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