+ Reply to Thread
Results 1 to 4 of 4

Help with a chart

  1. #1
    Registered User
    Join Date
    06-05-2010
    Location
    California
    MS-Off Ver
    Excel 2003
    Posts
    24

    Help with a chart

    I have a chart with numbers ranging from like 80-100, but what's annoying is the bars go from 0-100. How do I change it so it only goes from 80-100 and not 0-100? Otherwise the bars on my chart are unnecessarily long.

  2. #2
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: Help with a chart

    Have a look here:

    http://office.microsoft.com/en-us/ex...005199141.aspx

    or here

    http://books.google.ca/books?id=4nJo...page&q&f=false
    Last edited by Cutter; 02-10-2011 at 08:16 PM.

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

    Re: Help with a chart

    column/bar charts that do not come off of a zero datum line can be misleading.
    Use non zero datum with caution.
    Cheers
    Andy
    www.andypope.info

  4. #4
    Registered User
    Join Date
    03-24-2011
    Location
    Redmond, WA
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Help with a chart

    What version of Excel are you using? The first link suggested is a good one if you're using Excel 2003. If you're running Excel 2007, you might try this one instead: http://office.microsoft.com/en-us/ex...163.aspx?CTT=1
    Good luck.

+ 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