We’d like to remind Forumites to please avoid political debate on the Forum.

This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.

📨 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!

Graphs and pie charts?

Hey whats the easiest way to create basic graphs and pie charts? MS Word or Excel, can someone please give me a step by step guide?

Comments

  • poppy10_2
    poppy10_2 Posts: 6,588 Forumite
    Part of the Furniture 1,000 Posts Name Dropper
    What version of Excel are you using?
    poppy10
  • outlaw777
    outlaw777 Posts: 881 Forumite
    Part of the Furniture 500 Posts Name Dropper Combo Breaker
    Excel 2007?
  • spg_SCOTT
    spg_SCOTT Posts: 171 Forumite
    edited 20 July 2010 at 8:39AM
    First for a Pie Chart, you need two columns.

    Left Column is the relevant sections, Right Column is the values.

    Excel will take the title off of the top of the right column, so put the title at the top of it.

    Once you have the full table, highlight it, and click on 'Insert' on the ribbon on the top, then pie, then select the type of chart

    Example: http://dl.dropbox.com/u/3105891/Capture.GIF

    EDIT: It also works the same way for other graph types...
    -Scott-

    “There is a computer disease that anybody who works with computers knows about. It's a very serious disease and it interferes completely with the work. The trouble with computers is that you 'play' with them!” Richard Feynman
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
  • 352.4K Banking & Borrowing
  • 253.7K Reduce Debt & Boost Income
  • 454.4K Spending & Discounts
  • 245.4K Work, Benefits & Business
  • 601.2K Mortgages, Homes & Bills
  • 177.6K Life & Family
  • 259.3K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16K Discuss & Feedback
  • 37.7K 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.