Excel 2016 Chart showing random dates in x axis
Applez00800
I'm simply trying to graph some time-scale data using a date column and 3 data columns, but Excel keeps screwing up the dates in the chart... (showing dates from year 1900-1903 instead of 2018)
All of my dates in the date column are between the 12th and 13th of November, 2018 (12/11/2018 and 13/11/2018) as in the screenshot, and the entire date column number format is set to Custom: dd/mm/yyyy HH:mm (why doesn't Excel have this format as a predefined format??). I have also tried simply using the Date number format as well with no luck.
The Excel chart doesn't seem to think these are dates, since in the x-axis axis options, the bounds are numeric, not dates:
The date column is actually calculated from the Unix timestamp column and converted to my timezone (+10.5hrs) using the formula:
(((A2/60)/60)/24)+DATE(1970,1,1)+TIME(10,30,0)
Edit: I've also tried to copy the date column and paste as values. No luck.
Can someone tell me how to get the dates in the chart to actually use the dates in the date column?
And let me know why there might be random dates everywhere in the first place?
Applez00800
I found the issue, it was due to me extending the chart source data beyond the rows that had values in them. I wanted to extend it a couple hundred blank rows below so that I could simply paste a new table of values each day and not have to re-source the chart data. Turns out you can't do this...
I selected just the rows with data in them and now it's displaying correctly.
이 기사는 인터넷에서 수집됩니다. 재 인쇄 할 때 출처를 알려주십시오.
침해가 발생한 경우 연락 주시기 바랍니다[email protected] 삭제
에서 수정
관련 기사
Related 관련 기사
- 1
Excel chart: How to reverse the X axis of time series data
- 2
Excel Chart, Axis Label decimal removal
- 3
showing negative excel axis without label
- 4
tickinterval not working high chart for x axis
- 5
Excel 2016: 3D column chart with transparency and no gap
- 6
Strange spacing of dates on x-axis (D3)
- 7
Calculated text column for Google Line Chart x-axis not working
- 8
Flags placement on x-Axis on dual pane chart
- 9
Two different x axis labels on line chart, chart.js react
- 10
How to tell Excel to plot one column on x axis and another column on vertical axis?
- 11
How do I change where the secondary axis data is plotted in Excel chart?
- 12
Google Charts - How to stretch x axis over chart's full width
- 13
NVD3 Line Plus Bar Chart X-Axis Ticks 잘못된 정렬
- 14
HRESULT로 Excel 2016 파일 열기 실패 : 0x800706BE
- 15
Excel 2016 및 후기 바인딩의 활성 X 오류
- 16
jquery random image showing in random div
- 17
Data not showing up in Google Chart
- 18
Data not showing up in Google Chart
- 19
Teechart Axis Item Modification of X axis Item
- 20
Step-chart in Excel
- 21
Excel Scatter Chart with Labels
- 22
Random Sampling in Excel
- 23
Multiple y-axis background colors for chart
- 24
Horizontal bar chart y axis alignment
- 25
Google chart vertical axis strange label
- 26
Excel COUNTIFS with mixed dates and logicals
- 27
A Hollow Pie Chart for showing Live Data on Browsers
- 28
How to move columns with drag and drop in Excel 2016?
- 29
Install Microsoft Excel 2016 via Office 365
몇 마디 만하겠습니다