Copy graphs from Excel to GUI

1 次查看（过去 30 天）
chlor thanks
chlor thanks 2016-7-7
评论： chlor thanks 2016-7-7
My task involves to copy an excel plot from say... worksheet3 named "X_Plot" of an excel file (D:\Files\Excel Plots.xlsx) directly to a GUI axes for display.
I wonder if this is possible? If so, what steps can I take and what syntax can be used?
If not, what should be done?
Thank you for reading my concern and I will really appreciate any guidance on this :)
  2 个评论
Geoff Hayes
Geoff Hayes 2016-7-7
chlor - are the Excel graphs generated using data from the Excel worksheets?
chlor thanks
chlor thanks 2016-7-7
编辑：chlor thanks 2016-7-7
Geoff- I don't believe the data and the plot are from the same excel file, since when I try to select data and edit the series, nothing pops up as highlighted values indicating the current series.
Plus there are already proper formatting done to the existing plots, so I try not to replot them using matlab...

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Guillaume
Guillaume 2016-7-7
编辑：Guillaume 2016-7-7
Excel charts and matlab figures are two very different beasts. There is no easy way to convert one to the other.
As per Geoff's question, you could copy the source data of the chart and regenerate the plots in matlab instead. If you really wanted to, you could query the properties of the chart and its subobjects (lines, axes, etc.) and try to match that with their nearest equivalent in matlab, but it's probably a lot more work than you just recreating the graph from scratch.
Alternatively, you could copy the chart as a picture and display that as an Image in matlab but that would not be editabla and is probably not what you want.
  1 个评论
chlor thanks
chlor thanks 2016-7-7
Copy the chart as a picture is probably what I will prefer, thank you very much for your information, I will look more into the second option for this moment.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by