+ Reply to Thread
Results 1 to 3 of 3

additonal bars not showing up on charts

  1. #1
    Registered User
    Join Date
    10-30-2013
    Location
    Boise, ID
    MS-Off Ver
    Excel 2010
    Posts
    36

    additonal bars not showing up on charts

    I am fighting with Excel.

    I have a set of data points that I need charted, This will show the time frame of certain grants, but I can't get excel to read all the rows......My chart data is from A26 title bar.... A27-A32 Are the Axis points..... Data is D27-E32 Duration of time D being formatted to Read OCT-17 and E being Duration in days. Formula is correct: =SERIES(Funding_Data!$E$26,Funding_Data!$A$27:$A$32,Funding_Data!$E$27:$E$32,2)

    I attached the results of my graph. Can anyone tell me why this is not reading correctly? If I change the formula to read E: D My excel freaks out, starts flashing then freezes up and crashes......


    any advice is greatly appreciated
    Attached Images Attached Images

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    14,897

    Re: additonal bars not showing up on charts

    My guess is that something is wrong or unexpected with the values in column D or column E, but I cannot see what is wrong from the picture. My advice is to look very closely at what values are in column D and column E and see if it is exactly what you expect.

    1a) Format dates in some form of mm/dd/yyyy to see the entire date being represented. From your description and picture, I cannot tell if these are month -- year dates or if they are month-day (year 2017 implied???) values. Format them as the full month, day, year so you can see what date is actually stored in the cells in column D.
    1b) Alternatively, format these cells as general so that you can see the serial number stored in these cells. Remember that the actual value behind dates (assuming they are not dates stored as text strings, which you chart will interpret as the number 0) is a number that represents the number of days since Jan 1 1900 (the date 17 Oct 2017 is serial number 43025, for example). By removing the number format, you can see the underlying serial number and see if the numbers are something reasonable.
    1c) If neither 1a or 1b result in a change in the display of the cells, then the values are likely "dates stored as text" and you need to convert them to real date/time serial numbers. You can test using the ISTEXT() function. A VALUE() function, or a Text to columns command, or some other strategy will be needed in this case to convert the date strings to real date/time serial numbers.
    2) Make sure the number of days in column E is correctly calculated/entered. Make sure they are numbers and not numbers stored as text.

    I cannot readily think of anything else to suggest without seeing the actual file.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    10-30-2013
    Location
    Boise, ID
    MS-Off Ver
    Excel 2010
    Posts
    36

    Re: additonal bars not showing up on charts

    Thank you so much for your Post! I took fresh eyes to it today, and utilized the value formula to ensure the true value was being calculated. Additionally I pulled up excel help menu, and the formula calculations were set to Manual instead of Automatic. The graph is now pulling correctly. Thank you so 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. Showing bars that does not start from zero
    By eustechin in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-19-2017, 02:09 AM
  2. Error Bars not showing up on Graph
    By raven3321 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-15-2016, 02:54 AM
  3. [SOLVED] Showing Percentage As Bars In The Pivot Report
    By zanshin777 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-30-2015, 04:41 PM
  4. Error bars not showing up for 1-variable data
    By Kinzie in forum Excel General
    Replies: 0
    Last Post: 01-21-2015, 05:39 PM
  5. Custom error bars not showing
    By JMU_TOM in forum Excel General
    Replies: 1
    Last Post: 08-04-2011, 10:01 AM
  6. Bars in Gantt chart showing values of certain cells?
    By darelooney in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-20-2008, 10:10 AM
  7. [SOLVED] Putting text percentage at top of the bars showing the difference
    By lah in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-16-2005, 10: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