{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://www.manongdao.com/data/attach/logo/logo.png', '推荐 Fickle 薄情 的问题《How to show dates in a chart in Excel?》','https://www.manongdao.com/q-1123126.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}
My date data in x axis is in this format: 11/15 (without year). How to show dates in a chart from 15Nov to 29Apr in Excel? Below chart is not correct. The first dates have moved to end.
相关问题
- Excel sunburst chart: Some labels missing
- Date with SimpleDateFormat in Java
- Error handling only works once
- Excel formula in VBA code
- Excel VBA run time error 450 from referencing a ra
相关文章
- Mercurial Commit Charts / Graphs [closed]
- Change color of bars depending on value in Highcha
- Get column data by Column name and sheet name
- MYSQL: How can I find 'last monday's date&
- programmatically excel cells to be auto fit width
- Calculate number of working days in a month [dupli
- Unregister a XLL in Excel (VBA)
- Get file created date in node
I converted dates to text using: =TEXT(B2,"mm/dd") for all of rows.
Excel will add a default year (current year) for you when you enter just the month and day. so 15-Nov is actually 15-Nov-2017, and 29-Apr will also be 29-Apr-2017. So the 29-Apr will be assumed sooner than 15-Nov. I know you want 15-Nov for previous year and 29-Apr for next year but excel does no know your meaning..
So, you have to add the year part to your dates (even manually or using an formula) to specify exact order of dates and then use a format string to hide year in your cells like as
mmm/dd.