We’re putting the final touches on our new badges platform. Badge issuance remains temporarily paused, but all completions are being recorded and will be fulfilled once the platform is live. Thank you for your patience.
General Mechanical

General Mechanical

Topics related to Mechanical Enterprise, Motion, Additive Print and more.

How to adjust time displayed for creating a graph in excel?

TAGGED: , ,

    • MickMack
      Subscriber

      Hi,

      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.

      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.

      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.


      How do i increase the time precision to 5 decimal places?


      Any other advice on effeecient and effective ways to generate charts would be greatly appreciated.


      Regards,

      Michael

    • Erik Kostson
      Ansys Employee
      Hi

      Try to go to Workbench and main menu -> Tools -> Appearance and significant digits (as shown below) and change that to 9 say and press OK.




      All the best

      Erik
    • MickMack
      Subscriber

      That worked perfectly thank you very much, i include a snippet below with the same times highlighted.

      Can i also ask is this the most efficient way for generating graphs in excel?
      Regards Michael




    • Erik Kostson
      Ansys Employee
      Hi

      I would say copy the table and paste into excel .
      One can also right mouse button click on results objects (say Stress, Total Deformation,...) -> export a txt/csv file.
      All the best

      Erik
    • MickMack
      Subscriber
      Many Thanks
Viewing 4 reply threads
  • The topic ‘How to adjust time displayed for creating a graph in excel?’ is closed to new replies.