+ Reply to Thread
Results 1 to 6 of 6

Cant make chart, the gap in value is too large.

  1. #1
    Forum Contributor
    Join Date
    06-28-2013
    Location
    usa
    MS-Off Ver
    Excel 2013
    Posts
    155

    Question Cant make chart, the gap in value is too large.

    I am trying to make a bar chart, but the values are very wide in difference. When I make my bar chart, it does not look good at all

    For example...

    apples 2
    oranges 7
    grapes 4214
    pears 20
    carrot 20

    Notice grapes has a very much larger number, which skews the lower numbers.

    1. Do I play around with the axis or will that not help?
    2. Or do I change the chart type, if so, to what?

    screen shot of my chart
    Untitled.png

  2. #2
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    2010
    Posts
    1,738

    Re: Cant make chart, the gap in value is too large.

    An option is in the numeric access scale you can make the access logarithmic

  3. #3
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    UK
    MS-Off Ver
    2016 primarily
    Posts
    4,017

    Re: Cant make chart, the gap in value is too large.

    I'd suggest reading Jon's article here: https://peltiertech.com/broken-y-axis-in-excel-chart/
    Rory
    Sue, you're shouting at tea

  4. #4
    Forum Contributor
    Join Date
    06-28-2013
    Location
    usa
    MS-Off Ver
    Excel 2013
    Posts
    155

    Re: Cant make chart, the gap in value is too large.

    This scale correct? I have been adjusting it but so far no luck. I am wondering if this data just isnt able to be put in a chart because of the large difference in values.
    Capture.JPG

  5. #5
    Forum Contributor
    Join Date
    06-28-2013
    Location
    usa
    MS-Off Ver
    Excel 2013
    Posts
    155

    Re: Cant make chart, the gap in value is too large.

    thank you! i will read it now. @rorya

  6. #6
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    2010
    Posts
    1,738

    Re: Cant make chart, the gap in value is too large.

    The other article is more detailed, but jus tick the box, it will display on one chart, the more you need to reduce the scale the bigger you make the base, but 10 is likely to be ok

+ 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