+ Reply to Thread
Results 1 to 7 of 7

Help with a chart with lots of data

  1. #1
    Registered User
    Join Date
    10-22-2011
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    4

    Question Help with a chart with lots of data

    Hello. I am currently working on a chart in excel for a psychology project in school. I had to get six people to fill out a paper with several different personality choices that they felt fit me best. They each picked 20 of the list, and I have to talley them up. I want to show them in a bar chart so that they are easily viewable in my report, and have been working at it for two days to get to the point I am at.

    So, what I have is 2 columns to the left of my chart. In the "A" column, I have the word that is being counted, and in the "B" column adjacent to that word, I have that cell set up to count the number of instances the word appears in a results chart I made on another worksheet tab. I used the COUNT IF function in order to get my results, which worked well. EX: Cell A1 I have the text word "considerate". The formula in cell B1 is as follows: =COUNTIF(Sheet1!$A$6:$G$25,"suspicious") which gives me my results, going down a cell for each word, a total of 58 cells in each column. I then applied them to a bar graph as shown below. The chart shown below in this picture is the chart I need help with.

    http://i1131.photobucket.com/albums/.../excelhelp.png

    My information came from this table below:

    http://i1131.photobucket.com/albums/...xcelhelp_2.png

    Of course, because there is so much data, I need the chart to fit the entire page. I wanted a beautiful, interesting 3D bar chart to display, but unfortunately I do not know whether or not if it's going to actually be effective that way. 2D might be better and I may have to simplify and I am open to suggestions. I would like to keep this sort of color theme because it is matching with colors I have set up for my report in Word.

    I was wondering if there was also a way that I could possibly separate this data...like imposing a line chart displaying the smaller amount of hits, like 3 and under, then the bar chart could display the larger amount of hits. I saw there's a way to do so by separating axes somehow but it has been next to impossible for me to find information that can show me how to accomplish this in a manner to which I can comprehend. I am willing to post whatever information it may be that anyone needs in order to help me...I have been working at this chart for two days now and I am so frustrated that I would appreciate any help at all.

    Thank you very much.

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Help with a chart with lots of data

    It would be worth looking at Andy Pope's site and the examples of charts to see if there is anything there that you like the look of.

    http://www.andypope.info/charts.htm

    Incidentally, the COUNTIF formula that you used could be simplified.

    Please Login or Register  to view this content.
    Martin

  3. #3
    Registered User
    Join Date
    10-22-2011
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Help with a chart with lots of data

    Thank you for the link. I looked over what he had, and I think that I will most likely stick with the format of what I have so far.

    Thanks also for the simplification regarding the COUNT IF. I am wondering if at this point, it would be best for me to simply make the chart the full printable size on the paper. Is there a way for me to hide the previous two columns, or just put that chart onto another worksheet, then blow it up to full size to print?

  4. #4
    Registered User
    Join Date
    10-22-2011
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Help with a chart with lots of data

    I have managed to find information on how to move/copy my table onto another worksheet by itself. I am now trying to change the size of the table so that it fills the entire print area, i.e. make the table as big as possible. Does anyone know how I can do this without just dragging the box size?

  5. #5
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Help with a chart with lots of data

    Suggest that you set the print area to be the table that you are interested in and then use page set up to control the magnification.

  6. #6
    Registered User
    Join Date
    10-22-2011
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Help with a chart with lots of data

    Oh, thank you. I will give that a try. I know how to set a print area so that should be easy for me. I will then go to page setup to control the size...is there a magnification option there that you are talking about when it comes to changing the size? I hope I am not being too frustrating...I know how that can be sometimes when you're trying to help.

  7. #7
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Help with a chart with lots of data

    Magnification is controlled by Scale which you will find on the Page Layout ribbon.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1