+ 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
    192

    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
    365 and rarely 2016
    Posts
    3,198

    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
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,885

    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

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

    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
    192

    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
    365 and rarely 2016
    Posts
    3,198

    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)

Similar Threads

  1. Column chart - one error bar is too large for the chart
    By EON87 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 01-31-2019, 01:44 PM
  2. Large Excel file- how can I make it run faster?
    By georgia1852 in forum Excel General
    Replies: 1
    Last Post: 07-13-2014, 03:26 PM
  3. Break single large value to make bar chart more useable?
    By Kevingardner1 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-01-2011, 03:54 AM
  4. Why is my workbook so large (7.34mb) and is there a way to make it smaller?
    By jonvanwyk in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 03-25-2011, 02:20 PM
  5. Make a screenshot of large range of data
    By ABSTRAKTUS in forum Excel General
    Replies: 2
    Last Post: 05-26-2010, 10:51 AM
  6. [SOLVED] Make excel run large spreadsheets faster
    By username22 in forum Excel General
    Replies: 1
    Last Post: 10-29-2005, 11:05 AM
  7. can I make a chart with large amount of information?
    By Snoozin in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 09-14-2005, 09:05 AM

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