Announcement

Collapse
No announcement yet.

How to create graphs from data in a column in excel

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to create graphs from data in a column in excel

    Hi

    My knowledge of Excel is virtually nil. I am using Excel 2010 and have recently arranged a survey, I was able to export this survey into a CSV file and now I have a number of different column with various questions in the survey compiled and below this i have in each row the answers.
    2 things I want to establish. Let me create an example:
    1st Column
    What version of Office do you use at home?
    Office 2003
    Office 2010
    Office 2007
    Microsoft Works
    Office 2010
    Office 2007
    Office 2010
    Other
    So imagine I have different options selected for each person who conducted the survey in rows going down. I no nothing about formulas so what I wish to do is for Excel to calculate the total number of answers and put this into a row at the bottom of the table alongside with the name of the answer. I then want to create some sort of graph to represent this information.
    What would be best and easiest way for me to do this.

    Someone is going to look at this question and laugh because I bet its really easy to do. If anyone can offer advice on good websites as a reference guide, that would be really handy.

  • #2
    Re: How to create graph from data in a column in excel

    I had to change your Title slightly to focus on your query.

    Remember, there is no "stupid questions" they don't exist.
    Anyway, see if this helps: http://www.addictivetips.com/windows...ts-and-graphs/
    Caesar's cipher - 3

    ZKHQ BRX HYHQWXDOOB GHFLSKHU WKLV BRX ZLOO UHDOLVH LW ZDV D ZDVWH RI WLPH!

    SFX JNRS FC U6 MNGR

    Comment

    Working...
    X