How do I Format the X-Axis (Excel 2010) in Units of Month/Days/Year h:mm ?

[EricMD]

There does not appear to be method within X-Axis' Format, of expanding the axis' units further -- if true - is there a "work-around"?

......I desire to plot the axis with these units and the closest I have come is using the XY Chart and this data but only the date and 8/29/2012 0:00 time shows up in the graph.


Here is the data:
[TABLE="width: 219"]
<TBODY>[TR]
[TD]Flow Rate-Calc-Kg/hr
Y axis</SPAN>
[/TD]
[TD]Date& Time

X axis </SPAN>
[/TD]
[/TR]
[TR]
[TD]1002</SPAN>
[/TD]
[TD="align: right"]8/29/2012 8:14 AM</SPAN>
[/TD]
[/TR]
[TR]
[TD]1069</SPAN>
[/TD]
[TD="align: right"]8/29/2012 8:58 AM</SPAN>
[/TD]
[/TR]
[TR]
[TD]1050</SPAN>
[/TD]
[TD="align: right"]8/29/2012 9:39 AM</SPAN>
[/TD]
[/TR]
[TR]
[TD]1069</SPAN>
[/TD]
[TD="align: right"]8/29/2012 10:29 AM</SPAN>
[/TD]
[/TR]
[TR]
[TD]1003</SPAN>
[/TD]
[TD="align: right"]8/29/2012 11:13 AM</SPAN>
[/TD]
[/TR]
[TR]
[TD]1000</SPAN>
[/TD]
[TD="align: right"]8/29/2012 11:56 AM</SPAN>
[/TD]
[/TR]
[TR]
[TD]1010</SPAN>
[/TD]
[TD="align: right"]8/29/2012 12:50 PM</SPAN>
[/TD]
[/TR]
[TR]
[TD]1007</SPAN>
[/TD]
[TD="align: right"]8/29/2012 1:27 PM</SPAN>
[/TD]
[/TR]
[TR]
[TD]1007</SPAN>
[/TD]
[TD="align: right"]8/29/2012 1:59 PM</SPAN>
[/TD]
[/TR]
[TR]
[TD]1010</SPAN>
[/TD]
[TD="align: right"]8/29/2012 2:27 PM</SPAN>
[/TD]
[/TR]
[TR]
[TD]1007</SPAN>
[/TD]
[TD="align: right"]8/29/2012 3:13 PM</SPAN>
[/TD]
[/TR]
[TR]
[TD]1012</SPAN>
[/TD]
[TD="align: right"]8/29/2012 3:57 PM</SPAN>
[/TD]
[/TR]
[TR]
[TD]1016</SPAN>
[/TD]
[TD="align: right"]8/29/2012 4:44 PM</SPAN>
[/TD]
[/TR]
[TR]
[TD]1008</SPAN>
[/TD]
[TD="align: right"]8/29/2012 5:40 PM</SPAN>
[/TD]
[/TR]
[TR]
[TD]1004</SPAN>
[/TD]
[TD="align: right"]8/29/2012 6:24 PM</SPAN>
[/TD]
[/TR]
[TR]
[TD]1002</SPAN>
[/TD]
[TD="align: right"]8/29/2012 7:18 PM</SPAN>
[/TD]
[/TR]
[TR]
[TD]1009</SPAN>
[/TD]
[TD="align: right"]8/29/2012 7:59 PM</SPAN>
[/TD]
[/TR]
[TR]
[TD]1012</SPAN>
[/TD]
[TD="align: right"]8/29/2012 9:00 PM</SPAN>
[/TD]
[/TR]
</TBODY>[/TABLE]





Any tips/direction would be appreciated.


Thank You

EricMD

 

[cyrilbrd]

Hi,

Select your data, create your chart, select X axis, format / scale / Horizontal axis type set as "Text".

 

[EricMD]

Thank You - I had not realized that conversion to text captures the consecutive time lines and my comparision of flow rates for multi-lines for the same time period allows exquisite visual comparision. EricMD

Hi,

Select your data, create your chart, select X axis, format / scale / Horizontal axis type set as "Text".

 

[cyrilbrd]

Cool, thanks for the feedback.