Export data from charts

[Ash Zam]

I am making charts in Stata. However, I would also like to remake some of these graphs in Excel.

Is it possible for Stata to output the data that a chart consists of (only the variables that are being shown on the graph) to another datafile like Excel so I can remake the charts with the data that Stata has organized? Thank you!

[Nick Cox]

Why not just export the data any way?

[Ash Zam]

There's just quite a bit of data and I can't export the whole dataset to Excel unfortunately

[Nick Cox]

I don't follow. If the graph is based on the data, then the graph data won't be simpler than the raw data. On the other hand, if the graph shows a reduction of the data, then it's the same reduction that should be exported directly, e.g. as a set of group means.

[Sergiy Radyakin]

I am making charts in Stata. However, I would also like to remake some of these graphs in Excel.

Is it possible for Stata to output the data that a chart consists of (only the variables that are being shown on the graph) to another datafile like Excel so I can remake the charts with the data that Stata has organized? Thank you!

The general answer is probably negative, since Stata can build charts which have no equivalence in Excel, for example:
https://www.stata.com/support/faqs/g...unflower-plot/

This is probably not the chart that you want to recreate. Hence I'd suggest you refine your question with as much detail as possible that would help determine the feasibility and the compromises you are willing to make.

Also, you may want to describe why you wish to do this. Often times the desire to waste time on such a task is not self-induced, but rather is coming from an outsider instruction a la "Please send the charts in high resolution" or something similar, which should be addressed differently then rebuilding the charts in Excel.

Best, Sergiy

PS: I assume you are looking for a simple solution, that you can fulfill within a few hours. Otherwise the strict answer is yes: Excel has a Visual Basic component with which you can write a virtual machine, on which emulate Windows and Stata and with some luck and violation of a bunch of patents and copyrights produce the same graphs, technically "in Excel". The amount of developer-years for this scenario would be in the tens of thousands, I imagine...