How to complex number processing for graph plot?
Show older comments
I refer to the paper and practice calculating the transfer matrix through displacement and force at the boundary of the meta-structure, and plotting the effective property graph through it.
So, for this purpose, the displacement value and stress value were obtained using comsol and stored in Excel, where stress is in the form of complex numbers, so it is difficult to process it. First of all, I'm only extracting the real part from the complex number and using it, but I think there's a problem with this part, so I'm trying to get help.
I have attached the code I am using, the graph currently being plotted (left), and the target graph (right) and If you need an Excel file, please mention it in the answer
You can ignore the Y-axis scale.

1 Comment
Walter Roberson
on 4 May 2023
Excel has no way to store complex numbers -- other than that you can purchase an extension macro that works by storing an "object" at each location to hold the two parts. MATLAB does not give any way of writing values in the format that would be needed by that extension.
To store complex numbers in Excel from MATLAB, you would break them into real and imaginary components in separate cells.
Accepted Answer
More Answers (0)
Categories
Find more on Creating, Deleting, and Querying Graphics Objects in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!