EXCEL DATE AXIS NOT WORKING SERIES

Here is what you get if you change the base units from the automatic choice of days to either months or years:Дefinitely not what I was wanting. This chart has its uses, but not what I was looking to do. This chart does a really good job at showing how often the data is occurring but it is difficult to compare the columns because of the extra white space. In this case, the smallest difference is 5 days, so it will choose Days as the Base Unit. Why is it doing this? As the Excel help text states, it will choose the base units based on the smallest difference between any two dates in the chart data.

EXCEL DATE AXIS NOT WORKING SERIES

For instance, if your chart series categories are dates but are not in sequential order and you just want to see a column chart with only the dates chosen, however, this is how the Automatic choice of date (time scale) axis will look: This automatic date (time scale) setting may not cause you a problem, but in some cases it may not be what you want to see. For example, if you have data for stock prices where the smallest difference between dates is seven days, Excel sets the base unit to days, but you can change the base unit to months or years if you want to see the performance of the stock over a longer period of time.вЂќ вЂњA date axis displays dates in chronological order at specific intervals or base units, such as the number of days, months, or years, even if the dates on the worksheet are not in sequential order or in the same base units.Д«y default, Excel determines the base units for the date axis, based on the smallest difference between any two dates in the worksheet data. Here is what Microsoft Excel Help states on the subject: If it recognizes text, it will set your axis categories as text, if it recognizes dates, it will set up your chart using the Excel date (time scale) axis вЂ“ Automatically. When you use dates as a chart category in Excel, Excel applies the best setting for your data. In your Excel Executive Dashboards you may use date categories in your charts, however, this may have unintended consequences that you didnвЂ™t know. Many users think they are getting an axis error when they say that their column or line charts are showing every date between data points, but all they want to show is the dates related to the data.

Excel date axis not working