Use case versus time series x date

Question

Why Excel ignores the time component of date and time values ​​in a chart. For example, the following data:

10/10/2010 9:30 1 10/10/2010 9:40 2 10/10/2010 9:50 3 10/10/2010 10:00 4 10/10/2010 10:10 5 10/10/2010 10:20 6 

excel displays all values ​​on the same x value 10/10/2010. If I format the values ​​as time, it works fine. How can I show excel to display date and time and interpret it as a date-time not specified.

Answer 1

Try using an XY Scatter graph with a datetime formatted as YYYY-MM-DD HH: MM.

This provides a reasonable schedule for me (using Excel 2010).

Answer 2

There is one way to do this. So that the x axis treats the values ​​as text.

in Excel 2007, click on the chart - go to the layout menu (context menu when you click on the chart), select the option Axis-> Main horizontal axes-> Additional parameters for horizontal axes <w> In the Axis type section, select " Text axis "

Answer 3

I know this is an old question, but I tried my best to do it with a time period of more than 2 hours, so this can help someone. In addition, some of the answers do not actually plot against time, giving equal space regardless of duration.

First, as @jameswarren says, use a scatter graph. Then right-click on the horizontal axis and select Format Axis.

In the "Number" field, select "Time", and at this point you may find that your scale is a little crazy, because it chooses to scale the axis daily. So, go back to the Axis options and select Fixed for the minimum, maximum and basic units.

To set the unit to hours, enter 1/24 = 0.0416667 (I used half of this to get half-hour increments). To start this with a round number, multiply it by the preferred number of hours and enter it in the Minimum field. In my case 08:00 = 0.333333

Answer 4

It was much more painful than it should be.

It turns out that there are two concepts: data format and axis format. You need to format the data series as time, then you format the graph display axis as date and time.

Graph of your data

Select all columns and insert your graph.

Format datetime cells

Select a column, right-click, format cells. Select a time so that the data is in time format.

Now format the axis

Now right click on the axis text and change it to display any format you want

Answer 5

You will need to specify TimeSeries in Excel to plot. Look this

Answer 6

[excel 2010] splits the date and time into separate columns and selects both X-Axis and data as a series of graphs see http://www.79783.mrsite.com/USERIMAGES/horizontal_axis_date_and_time2.xlsx

Answer 7

There is an easy workaround for this problem.

What you need to do is format your dates as DD / MM / YYYY (or whatever method you like)

Insert a column next to the time and date columns, put the formula in this column, which will add them together. e.g. = A5 + B5.

Format this inserted column in the format DD / MM / YYYY hh: mm: ss, which can be found in the user category in the formatting section

Scatter plot

Badabing badaboom

If you are unsatisfied with this workaround, learn to use GNUplot :)