To post as a guest, your comment is unpublished.· 1 months agoHi, TJ Roberts, this tutorial may help you https://www.extendoffice.com/documents/excel/4374-excel-skip-blanks-in-chart.html
How to create a chart with date and time on X axis in Excel?
In Excel, we usually insert a chart to better describe the data. But in some cases, when you create a column/bar/line chart based on a series of date and time, the X axis of the chart may be shown as below screenshot. And in this article, I introduce the way for how to show the date and time on X axis correctly in the Chart.
Create a speedometer chart with two steps！
|Sometimes, you may want to use a speedometer chart to display the pricessing of a project, but in Excel, to create a speedometer chart needs many steps which is complex and wasting time. Here, the Speedometer chart tool in Kutools for Excel can help you create a standard speedometer chart by two simplesteps. Download this tool with free 60-day trial now.|
- Reuse Anything: Add the most used or complex formulas, charts and anything else to your favorites, and quickly reuse them in the future.
- More than 20 text features: Extract Number from Text String; Extract or Remove Part of Texts; Convert Numbers and Currencies to English Words.
- Merge Tools: Multiple Workbooks and Sheets into One; Merge Multiple Cells/Rows/Columns Without Losing Data; Merge Duplicate Rows and Sum.
- Split Tools: Split Data into Multiple Sheets Based on Value; One Workbook to Multiple Excel, PDF or CSV Files; One Column to Multiple Columns.
- Paste Skipping Hidden/Filtered Rows; Count And Sum by Background Color; Send Personalized Emails to Multiple Recipients in Bulk.
- Super Filter: Create advanced filter schemes and apply to any sheets; Sort by week, day, frequency and more; Filter by bold, formulas, comment...
- More than 300 powerful features; Works with Office 2007-2019 and 365; Supports all languages; Easy deploying in your enterprise or organization.
To display the date and time correctly, you only need to change an option in the Format Axis dialog.
1. Right click at the X axis in the chart, and select Format Axis from the context menu. See screenshot:
2. Then in the Format Axis pane or Format Axis dialog, under Axis Options tab, check Text axis option in the Axis Type section. See screenshot:
3. Click Close or go back to the chart, then then date and time data has been correctly display in the X axis. See screenshot:
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
To post as a guest, your comment is unpublished.· 1 months agoHow do I remove days that don't have data in them. Example 8/1-8/31 but not data was captured on 8/3 or 8/4, how do I remove those dates from my graph? They are not in my data table so why is it pulling them?
To post as a guest, your comment is unpublished.
To post as a guest, your comment is unpublished.· 5 months agoEasy, useful, but i didn't know. Thanks a lot
To post as a guest, your comment is unpublished.
To post as a guest, your comment is unpublished.· 11 months agoThis is not OK. It does not show correct order by time just puts the timestamps there as a text in equal distances.
To post as a guest, your comment is unpublished.· 4 months agoI'm having the same issue. It would be better for the x-axis to show the time not as evenly spaced category labels, but in actual proportion to the durations between the time values. Example: Here's data on world population by year (note that the intervals between years are not evenly spaced):
An Excel line chart depicts this data on a fairly even slope (I'd post a picture, but this interface only allows text); however, the generally declining time intervals SHOULD yield a graph that looks much more exponential.
I was able to "fake" it by inserting rows in the data table for each year with no data (e.g., 122 rows for the years between 1804 and 1927 exclusive, 32 rows for the years between 1927 and 1960, etc.), so my graph looks more proportional now, but this has its own disadvantages. There are MANY empty rows and much wasted table space. I'd love to learn a better way to get Excel to treat time values in the x-axis as actual time values, rather than mere category labels
To post as a guest, your comment is unpublished.· 9 months agoHello, Vilmos, create the chart after you order the time data, then the chart will display the time in order.
To post as a guest, your comment is unpublished.· 5 months agoNope, you didnt' understand him. It's not proportional.
To post as a guest, your comment is unpublished.· 4 months agoexactly.
i am looking desperately for that.
do you know any other software to create that graph?
To post as a guest, your comment is unpublished.· 2 months agoI did it in Google Sheets, and it was pretty straight forward.
It was able to graph using a column with DateTime values for the x-axis, with appropriate spacing, and without having to resort to treating that column as text. It worked with the cells in that column formatted as either a date, or in datetime format. There weren't many options for the spacing on the x-axis lables, but at least you can hover over the trends and see the x-axis value for a given point, in whatever way the cells are formatted. Frustrating that there doesn't seem to be a way in Excel.