blocks|key|439549|text|您需要在Excel中指定要打印的TimeSeries。看一看this|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|439550|​|439551|📷|atomic|439552|439553|entityMap|0|LINK|mutability|MUTABLE|url|http://www.mrexcel.com/articles/excel-time-series-chart.php|1|IMAGE|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/45226348e9b7fc79d2a3d3f201eb61a9.gif|imageAlt^0|U|4|0|0|0|0|1|1|0|0^^$0|@$1|2|3|4|5|6|7|X|8|@]|9|@$A|Y|B|Z|1|10]]|C|$]]|$1|D|3|E|5|6|7|11|8|@]|9|@]|C|$]]|$1|F|3|G|5|H|7|12|8|@]|9|@$A|13|B|14|1|15]]|C|$]]|$1|I|3|E|5|6|7|16|8|@]|9|@]|C|$]]|$1|J|3|-4|5|6|7|17|8|@]|9|@]|C|$]]]|K|$L|$5|M|N|O|C|$P|Q]]|R|$5|S|N|T|C|$U|V|W|-4]]]]

You will need to specify TimeSeries in Excel to be plotted. 
Have a look at <a href="http://www.mrexcel.com/articles/excel-time-series-chart.php" rel="nofollow noreferrer">this</a>

<img src="https://i.stack.imgur.com/kYxzU.gif" alt="Plotting Time Series">

blocks|key|221378|text|尝试使用日期时间格式为YYYY-MM-DD+HH:MM的X-Y散点图。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|221379|这为我提供了一个合理的图表(使用Excel2010)。|221380|​|221381|📷|atomic|offset|length|221382|221383|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/0f09f8b101be98e9fb106a5c2350c4c7.png|imageAlt^0|0|0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|V|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|W|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|X|8|@]|9|@$I|Y|J|Z|1|10]]|A|$]]|$1|K|3|E|5|6|7|11|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|M|$N|$5|O|P|Q|A|$R|S|T|-4]]]]

Try using an X-Y Scatter graph with datetime formatted as YYYY-MM-DD HH:MM.
This provides a reasonable graph for me (using Excel 2010).
<img src="https://i.stack.imgur.com/nnEBP.png" alt="Excel Datetime XY Scatter" />

blocks|key|221428|text|excel+2010将日期和时间分隔为单独的列，并同时选择X轴和数据图表系列请参见http://www.79783.mrsite.com/USERIMAGES/horizontal_axis_date_and_time2.xlsx|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|221429|entityMap|0|LINK|mutability|MUTABLE|url|http://www.79783.mrsite.com/USERIMAGES/horizontal_axis_date_and_time2.xlsx^0|15|22|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

[excel 2010] separate the date and time into separate columns and select both as X-Axis and data as graph series
see <a href="http://www.79783.mrsite.com/USERIMAGES/horizontal_axis_date_and_time2.xlsx" rel="nofollow">http://www.79783.mrsite.com/USERIMAGES/horizontal_axis_date_and_time2.xlsx</a>

blocks|key|221479|text|对于这个问题，有一个简单的解决方法|type|unstyled|depth|inlineStyleRanges|entityRanges|data|221480|你需要做的是将你的日期格式化为DD/MM/YYYY+(或者你喜欢的任何一种方式)|221481|在时间和日期列旁边插入一列，在此列中放入一个将它们相加的公式。例如=A5%2BB5。|221482|将此插入的列格式化为DD/MM/YYYY+hh:mm:ss，可在格式设置部分的自定义类别中找到|221483|绘制散点图|221484|巴达宾巴达博|221485|如果您对此解决方法不满意，请学习使用GNUplot+:)|221486|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|S|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|T|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|U|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|V|8|@]|9|@]|A|$]]|$1|N|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|O|$]]

There is an easy workaround for this problem

What you need to do, is format your dates as DD/MM/YYYY (or whichever way around you like)

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

Format this inserted column into DD/MM/YYYY hh:mm:ss which can be found in the custom category on the formatting section

Plot a scatter graph 

Badabing badaboom

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

blocks|key|439998|text|这比应该的要痛苦得多。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|439999|原来有两个概念，数据的格式和轴的格式。您需要将数据序列格式化为时间，然后将图形的显示轴格式化为日期和时间。|440000|用图表表示你的数据|440001|突出显示所有列并插入图表|440002|​|440003|📷|atomic|offset|length|440004|440005|设置日期时间单元格的格式|440006|选择列，右键单击，设置单元格格式。选择时间，以便数据采用时间格式。|440007|440008|440009|440010|现在格式化该轴|440011|现在，右键单击轴文本并将其更改为显示所需的任何格式|440012|440013|440014|440015|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/f6204e16b32520c682ad8e9f5228c539.png|imageAlt|1|https://ask.qcloudimg.com/http-save/yehe-900000/3b4d2560b3782b75ce0d3c6a6bfb8f0a.png|2|https://ask.qcloudimg.com/http-save/yehe-900000/18749c80b2d8a2ccb5a1eaf10035cb06.png^0|0|0|0|0|0|0|1|0|0|0|0|0|0|0|1|1|0|0|0|0|0|0|1|2|0|0^^$0|@$1|2|3|4|5|6|7|1G|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1H|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|1I|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|1J|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|1K|8|@]|9|@]|A|$]]|$1|J|3|K|5|L|7|1L|8|@]|9|@$M|1M|N|1N|1|1O]]|A|$]]|$1|O|3|I|5|6|7|1P|8|@]|9|@]|A|$]]|$1|P|3|Q|5|6|7|1Q|8|@]|9|@]|A|$]]|$1|R|3|S|5|6|7|1R|8|@]|9|@]|A|$]]|$1|T|3|I|5|6|7|1S|8|@]|9|@]|A|$]]|$1|U|3|K|5|L|7|1T|8|@]|9|@$M|1U|N|1V|1|1W]]|A|$]]|$1|V|3|I|5|6|7|1X|8|@]|9|@]|A|$]]|$1|W|3|X|5|6|7|1Y|8|@]|9|@]|A|$]]|$1|Y|3|Z|5|6|7|1Z|8|@]|9|@]|A|$]]|$1|10|3|I|5|6|7|20|8|@]|9|@]|A|$]]|$1|11|3|K|5|L|7|21|8|@]|9|@$M|22|N|23|1|24]]|A|$]]|$1|12|3|I|5|6|7|25|8|@]|9|@]|A|$]]|$1|13|3|-4|5|6|7|26|8|@]|9|@]|A|$]]]|14|$15|$5|16|17|18|A|$19|1A|1B|-4]]|1C|$5|16|17|18|A|$19|1D|1B|-4]]|1E|$5|16|17|18|A|$19|1F|1B|-4]]]]

That was much more painful than it ought to have been.

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

<h2>Graph your data</h2>

Highlight all columns and insert your graph

<a href="https://i.stack.imgur.com/eLFZt.png" rel="noreferrer"><img src="https://i.stack.imgur.com/eLFZt.png" alt="First graph your data"></a>

<h2>Format datetime cells</h2>

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

<a href="https://i.stack.imgur.com/yJRpa.png" rel="noreferrer"><img src="https://i.stack.imgur.com/yJRpa.png" alt="Format the cells"></a>

<h2>Now format the axis</h2>

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

<a href="https://i.stack.imgur.com/hehX4.png" rel="noreferrer"><img src="https://i.stack.imgur.com/hehX4.png" alt="Format axis as custom date"></a>

Why does Excel ignore the time component of datetime values in a chart. For example, the following data :

<pre><code>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
</code></pre>

excel plots it all values on a same x-value 10/10/2010.
If I format the values as time, it works fine. How do I tell excel to display datetime and interpret it as datetime not date..

excel plot against a date time x series

为什么Excel忽略图表中日期时间值的时间部分。例如，以下数据：10/10/2010 9:30   1 10/10/2010 9:40   210/10/2010 9:50   310/10/2010 10:00  4 10/10/2010 10:10  510/10/2010 10:20  6excel将所有值绘制在...

问excel针对日期时间x系列绘制图表
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问excel针对日期时间x系列绘制图表EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问excel针对日期时间x系列绘制图表
EN