+ Reply to Thread
Results 1 to 8 of 8

Histogram and graph issues

  1. #1
    Forum Contributor
    Join Date
    04-08-2009
    Location
    Bristol, UK
    MS-Off Ver
    Excel 2003
    Posts
    228

    Angry Histogram and graph issues

    Hi all,

    I may be having a complete dense moment but if you look at the attached .xls I just want to put the data into a graph like the one I have had to draw UGH!

    Am I missing something? I can't get the data to display like that. Should I be using a histogram and if so, how? Any helps or a quick step-by-step would be greatly appreciated.
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,130

    Re: Histogram and graph issues

    You need to change the layout of your data.

    As a general rule merged cells and charts don't mix.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Contributor
    Join Date
    04-08-2009
    Location
    Bristol, UK
    MS-Off Ver
    Excel 2003
    Posts
    228

    Unhappy Re: Histogram and graph issues

    Hi Andy (all)

    I tried that suggestion but I still can't get the graph layout I need.... Any more help? what type of graph should I be using?

    (see edited attached .xls)
    Attached Files Attached Files

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,130

    Re: Histogram and graph issues

    The empty cells in row 3 are confusing excel.

    Add a space to each cell in the range A3:P3 then try creating a stacked column chart on the range A1:P5.

    Set the gap width to 0.

  5. #5
    Forum Contributor
    Join Date
    04-08-2009
    Location
    Bristol, UK
    MS-Off Ver
    Excel 2003
    Posts
    228

    Re: Histogram and graph issues

    Sorry, not sure what you mean by 'space'. I know this is sounding dense but I am lost and appreciate your help and patience

  6. #6
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,130

    Re: Histogram and graph issues

    Press the long bar, normally found at the bottom of your keyboard. :P

    A space character or the formula =CHAR(32) . Excel just needs to think the cell is not empty.

  7. #7
    Forum Contributor
    Join Date
    04-08-2009
    Location
    Bristol, UK
    MS-Off Ver
    Excel 2003
    Posts
    228

    Re: Histogram and graph issues

    Wow. It's not going to be a good day is it... :p

    Maybe I bring a whole new meaning to the word 'Dense'...

    Thank you so very much for your help. You're a legend. Working perfectly now. Thank you.

  8. #8
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,130

    Re: Histogram and graph issues

    There's nothing less obviously than the bleeding obvious

    Glad your sorted.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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