Consulting

Results 1 to 6 of 6

Thread: Excel bar Chart invisible

  1. #1
    VBAX Regular
    Joined
    Apr 2008
    Posts
    12
    Location

    Post Excel bar Chart invisible

    Hi! All Need ur help in plotting chart in Excel 2003. I have data values ranging from 5 to 500. Iam plotting a bar chart in value axis if the value is equal to 5 bar graph is invisilbe or very tiny to look. Is there any way we can make bar visible but data value should be same.
    This just example value may be from 10 to 1000 also but data value 10 should be visible. I have attached sample file. Thank you in Advances for your helps.

    Regards
    Sats

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    If I understand you correctly, you could set the x-axis scale to logarithmic. This is what it would look like
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  3. #3
    VBAX Regular
    Joined
    Apr 2008
    Posts
    12
    Location
    Hi, Thank you for u reply! I need the same in normal scale and not with logarithimic scale. Waiting for your help

  4. #4
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    Not possible as far as I can see.

    But why? What is wrong with the logarithmic scale?
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  5. #5
    VBAX Regular
    Joined
    Apr 2008
    Posts
    12
    Location
    Solved! Thank u very much

  6. #6
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    Care to tell us how, for the archive?
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •