+ Reply to Thread
Results 1 to 5 of 5

Column histogram with +/- 50

  1. #1
    Registered User
    Join Date
    04-11-2011
    Location
    New York, NY
    MS-Off Ver
    Excel 2003
    Posts
    3

    Column histogram with +/- 50

    Hello. I'm trying to create a column based histogram with 50 as the centering point. As an example, if you normally had one column of negative numbers and one of positive numbers you could create a histogram with 0 as the center point and the positive numbers plotted above and the negative numbers plotted below. How might I accomplish that when all numbers are positive? I'd like 50 to be the center line and numbers 51-100 plotted above and numbers 49-0 plotted below.

    Here is an example.

    Thanks!

    http://img163.imageshack.us/img163/204/histogram.png

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

    Re: Column histogram with +/- 50

    Format the Value axis to Category (x) axis crosses at: =50
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    04-11-2011
    Location
    New York, NY
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Column histogram with +/- 50

    Thanks, Andy. All that seems to do is flip the chart upside down...

    Cross at 0:
    http://img848.imageshack.us/img848/6825/xcross0.png

    Cross at 50:
    http://img607.imageshack.us/img607/4219/xcross50.png

    Did I enter it incorrectly?
    http://img26.imageshack.us/img26/5525/xcrossscreen.png

    All the best,
    Morgan

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

    Re: Column histogram with +/- 50

    correct place but wrong value.

    50 as a percent is 5000%
    try using 0.5 = 50%

  5. #5
    Registered User
    Join Date
    04-11-2011
    Location
    New York, NY
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Column histogram with +/- 50

    Beautiful! Thanks a ton for your help.

+ 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