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. 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
    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.