The same problem would happen with Excel graphs. The solution is usually to create a PDF file in your application and place the PDF into InDesign.
Actually, that used to be a problem especially on Mac but it's not anymore.
Copy and paste of charts from Excel into InDesign will result in vector
artwork being pasted in and will give you a pretty good result for many
applications. The only potential issue would be black going to rich
black but beside that, I can't think of any thing else.
Tested with Excel 2013 Win and Excel 2011 Mac with InDesign CC.
I know that's a bit off topic here and I have no knowledge of Ecowin but
it's something to be aware of.
Thanks for updating me, Bob. Since I never get Excel graphs, that was just from memory of times past.
Yup. And really, unless you need to tweak the charts, there's no reason
to jump through hoops. That said, some of the funky fills and patterns
can be a problem so keep it simple and if you need them dressed up
copy/paste to Illustrator and do the tweaking there.
Thanks for your reply but unfortunately it does not solve the problem because, at least to my knowledge, it is not possible to convert an Ecowin graph to a pdf-file. The only option to bring an Ecowin-graph out from Ecowin is to select "copy graph" in the edit menu in the program. You can then paste it easily into e.g. Word, Excel or even an email. In Word and Excel, you can even paste it as an object such that when you click on the Ecowin graph in e.g. Word, the graph opens up in Ecowin.In InDesign CS2, this is not possible, but it i s possible to paste the graph and view and print it in high resolution. But not in CS6, or? I thought it was a matter of setting the correct settings in CS6?
Ok, it turns out that you can create a pdf file of the graphs in Ecowin, so at least technically you can solve the problem. Having said that, it is very time consuming to first pdf then snapshot the graph and then paste into InDesign, at least when we are talking about many graphs. If anyone else knows another, simpler and faster, solution, I would appreciate it if you post it.
But many thanks Steve for your post!
Why don't you just Place the PDF of the graph into ID instead of doing a screenshot/copy/paste?
Good question. The reason is that when pdf-ing the graph in Ecowin the resulting pdf-file is a one page with the graph taking up only about 50% of that page. To make it look good in InDesign I must therefore crop the pdf-page/graph. But "place" is perhaps different to "paste"? (I am very novice in InDesign). Any good suggestions to speed this workflow up is very welcomed. Another problem with cropping is that it never gets exact for all graphs (different pdf-files), but perhaps that can also be taken care of?
I have a suggestion that maybe isn't very helpful, but may lead to other similar and hopefully more efficient ideas. It will require one more step than the ideal, but at least you'll not have to manually crop anything.
- Paste the graph in Excel
- In Excel, select the graph, call the export to PDF command and remember to activate the "Current Graph" option (I don't know how exactly you do this in Windows; I tested on Mac Excel). This will create a PDF containing only the chart, not a PDF with the size of the page, with huge white borders around the graph.
- In InDesign, call the Place command. In the dialog box, activate "Show Import Options", select that PDF file and click the main button (or hit Enter/Return).
- Because you ask to "show import option", ID will display an additional dialog box. There, play with the "Crop to" options to see which of them will bring only the graph, without the page borders. In my tests, both "Bounding Box (All Layers)" and "Bounding Box (Visible Layers Only)" did the job; the others would bring the whole PDF, with the huge white margins.
That's it. Hope it helps.
If you can get it into Excel you can use copy/paste from there.
In the same line of my previous comment, you could see whether Ecowin itself offers the choice to export only a selection. Alternatively, you can try to change the document size to the same dimensions of the chart, which will potentially make the PDF the size you want.
Oh, my! Forget my clumsy suggestions. Bob is right: copying from Excel to InDesign is the easiest way to go.
Many thanks for your suggestions. We have no problem pasting the graphs into Excel, but copy/paste those graphs from Excel into InDesign does not work. When pasting it into a "graphic field" in InDesign, the "cross" over the area disappears as if something has been pasted. But the area is just blank, and it doesn't help to "fit content into frame". The graph does not become visible.
Just paste it. Don't paste it into anything.
And what version of Excel are you using?
Unfortunately it still does not work.
Were using Office 2010 Excel v.14.0.6123.5000, 32 bit.
Does not work tells us nothing. We need screenshots at the very least.