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

    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
    2003, 2007, 2010 & 2013
    Posts
    18,519

    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
    Ipswich, England
    MS-Off Ver
    Excel 2016 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    30,896

    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!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    2003, 2007, 2010 & 2013
    Posts
    18,519

    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
    Ipswich, England
    MS-Off Ver
    Excel 2016 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    30,896

    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
    37

    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
    Ipswich, England
    MS-Off Ver
    Excel 2016 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    30,896

    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
    37

    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)

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