+ Reply to Thread
Results 1 to 8 of 8

Missing collumn in a chart

  1. #1
    Registered User
    Join Date
    01-05-2013
    Location
    Sarajevo
    MS-Off Ver
    Excel 2007
    Posts
    40

    Missing collumn in a chart

    Hi!
    I have a strange problem with excel chart. The chart does not want to show value of cell although data is in cell. It works great for all other cells but for some reason it wont to show value of this cell. Just like in the picture Where is it .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: Missing collumn in a chart

    Hard to tell from a picture but ensure the values are true numeric ones and are not being treated as text. Text will appear in chart as zero.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,460

    Re: Missing collumn in a chart

    It's invisible, just like your workbook, without which we have no chance at all of helping.

    Will you please attach a small sample Excel workbook? We are not able to work with or manipulate a picture of one and nobody wants to have to recreate your data from scratch.

    Unfortunately the attachment icon doesn't work at the moment (it hasn't worked for years, and despite our repeatedly asking the technical team who own the forum to fix it, they can't be bothered to do so), so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

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

    Re: Missing collumn in a chart

    Just checked the pic again. Your minimum scale value is greater than the missing values. Adjust the vertical scale.

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,460

    Re: Missing collumn in a chart

    Ha, ha, ha - nice spot, Andy!

    Oops ...

  6. #6
    Registered User
    Join Date
    01-05-2013
    Location
    Sarajevo
    MS-Off Ver
    Excel 2007
    Posts
    40

    Re: Missing collumn in a chart

    hahahahahahahahhahaha ... man you are genious. I'm trying this for days can't get it . Thank you so much hahahhahaa

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,460

    Re: Missing collumn in a chart

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

  8. #8
    Registered User
    Join Date
    01-05-2013
    Location
    Sarajevo
    MS-Off Ver
    Excel 2007
    Posts
    40

    Re: Missing collumn in a chart

    Ok. Thank you all very much

+ 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. Replies: 2
    Last Post: 06-15-2018, 11:43 AM
  2. Missing Chart selector
    By paramedic9004 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-27-2015, 09:45 AM
  3. [SOLVED] Find a collumn in a dynamic sheet and select the entire collumn
    By Armand0 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-03-2014, 11:20 AM
  4. Collumn chart: Variable usage over time
    By Svante in forum Excel General
    Replies: 3
    Last Post: 08-12-2010, 06:59 AM
  5. chart with some missing points
    By Violeta in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-15-2008, 03:15 PM
  6. Chart Lines Are Missing
    By Karleajensar in forum Excel General
    Replies: 2
    Last Post: 03-10-2008, 12:29 PM
  7. Chart's with missing numbers
    By Ctech in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 03-06-2007, 11:17 AM

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