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......
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.
Originally Posted by shg
Mathematics is the native language of the natural world. Just trying to become literate.
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.