Help with making a graph

Discussion in 'Excel Charting' started by Andrea, Jan 27, 2009.

  1. Andrea

    Andrea Guest

    I am trying to make a graph and I can't get it the way I'm picturing in my head

    I have 200 patients who took a survey, then I had the total amount for their
    answers 1-24. I want a graph that shows me how many patients scored 0-4,
    5-9, 10-18, 18+...

    anyone help?
     
    Andrea, Jan 27, 2009
    #1
    1. Advertisements

  2. Make a table like this:
    Range Number
    0 - 4 45
    5 - 9 60
    10 - 18 40
    18+ 55

    Click any one of these cells.
    In Excel 2003 (and before) click the Chart Wizard tool and select a Column
    chart (the first on)
    In Excel 2007 open the Insert tab on the Ribbon and select a Column chart
    (the first one)

    You may need to format the chart to make it more attractive: borrow Excel
    fro Dummies from the library to see how

    Repeat the process making a Bar or a Line chart. Which one looks better for
    your purpose? Note that you cannot make an XY (Scatter) chart as you have
    'category data'

    best wishes
     
    Bernard Liengme, Jan 27, 2009
    #2
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.