{"id":159350,"date":"2021-06-10T11:28:37","date_gmt":"2021-06-10T11:28:37","guid":{"rendered":"\/forum\/forums\/topic\/how-to-adjust-time-displayed-for-creating-a-graph-in-excel\/"},"modified":"2021-06-10T14:04:16","modified_gmt":"2021-06-10T14:04:16","slug":"how-to-adjust-time-displayed-for-creating-a-graph-in-excel","status":"closed","type":"topic","link":"https:\/\/innovationspace.ansys.com\/forum\/forums\/topic\/how-to-adjust-time-displayed-for-creating-a-graph-in-excel\/","title":{"rendered":"How to adjust time displayed for creating a graph in excel?"},"content":{"rendered":"<div class=\"Item-Body\">\n<div class=\"Message userContent\">\n<p>Hi,<\/p>\n<p>I want to create a chart in excel (i assume this is the best program) comparing the directional velocity of two nodes from two separate models.<\/p>\n<p>I have simply copied the tabular data from Mechanical and pasted it into excel to create my chart. As the minimum time step is 0.00001, the time is in increments beyond 3 decimal places. <\/p>\n<p>However as highlighted in the snippet below, the time displayed is to 3 decimal places, therefore the values when imported into excel display the same time 10.318, which is inaccurate.<\/p>\n<p><\/p>\n<\/p>\n<p>How do i increase the time precision to 5 decimal places?<\/p>\n<p><\/p>\n<\/p>\n<p>Any other advice on effeecient and effective ways to generate charts would be greatly appreciated.<\/p>\n<p><\/p>\n<\/p>\n<p>Regards,<\/p>\n<p>Michael<\/p>\n<div class=\"embedExternal embedImage\">\n<div class=\"embedExternal-content\">\n<a class=\"embedImage-link\" href=\"\/forum\/wp-content\/uploads\/forum-uploads\/563\/NN1IBQLQQCQG.png\" rel=\"nofollow noopener\" target=\"_blank\"><br \/>\n<img decoding=\"async\" class=\"embedImage-img\" src=\"\/forum\/wp-content\/uploads\/forum-uploads\/563\/NN1IBQLQQCQG.png\" alt=\"image.png\" \/><br \/>\n<\/a><\/p>\n","protected":false},"template":"","class_list":["post-159350","topic","type-topic","status-closed","hentry","topic-tag-chart","topic-tag-precision","topic-tag-time"],"aioseo_notices":[],"acf":[],"custom_fields":[{"0":{"_bbp_author_ip":[""],"_bbp_old_reply_author_name_id":["Anonymous"],"_bbp_old_is_reply_anonymous_id":["false"],"_btv_view_count":["761"],"_bbp_likes_count":["0"],"_bbp_subscription":["231510"],"_bbp_topic_status":["unanswered"],"_bbp_status":["publish"],"_bbp_topic_id":["159350"],"_bbp_forum_id":["27791"],"_bbp_engagement":["58821","184101"],"_bbp_voice_count":["2"],"_bbp_reply_count":["4"],"_bbp_last_reply_id":["181713"],"_bbp_last_active_id":["181713"],"_bbp_last_active_time":["2021-06-10 14:04:16"]},"test":"mickmack"}],"_links":{"self":[{"href":"https:\/\/innovationspace.ansys.com\/forum\/wp-json\/wp\/v2\/topics\/159350","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/innovationspace.ansys.com\/forum\/wp-json\/wp\/v2\/topics"}],"about":[{"href":"https:\/\/innovationspace.ansys.com\/forum\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/innovationspace.ansys.com\/forum\/wp-json\/wp\/v2\/topics\/159350\/revisions"}],"wp:attachment":[{"href":"https:\/\/innovationspace.ansys.com\/forum\/wp-json\/wp\/v2\/media?parent=159350"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}