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.