Re: the correct program

Have you tried Insert, Object, from file, browse to the graph or chart?

--
Mary Sauer MSFT MVP
http://office.microsoft.com/
http://msauer.mvps.org/
news://msnews.microsoft.com

"David F" <dfrench119@xxxxxxxxx> wrote in message
news:uGYiATNfIHA.4744@xxxxxxxxxxxxxxxxxxxxxxx
The biggest issue has been bringing over a predefined area of information from
Excel and pasting it into either Publisher or Word. Pasted as a metafile
things are fuzzy...as straight paste extends off the page, parts of the paste
move around....
There are ranges of data, bar graphs, sometimes pie graphs and it's
hand-to-hand combat to make the information look even halfway decent.
These marketing people just want to make a professional looking report and it
looks like a 3rd grader did it.

The whole report is compiled currently in Publisher and finally sent to
Acrobat for conversion to PDF for security reasons. That is a whole other
story when PDF ends up making a chart a simple black box but that's not your
area of expertise.

If you have any suggestions I would sincerely appreciate it.

Dave

"Mary Sauer" <mary-sauer@xxxxxxxxxxxxxxxxx> wrote in message
news:O7DKiy9eIHA.5160@xxxxxxxxxxxxxxxxxxxxxxx
As you say, long documents are best done in Word.
If your goal is a good looking page layout, then Publisher is the product to
use.

You will have more problems moving images around in Word. Pages are difficult
to define. But then you don't have to contend with text boxes.

From the way you explained, you might be well off creating a report in Excel.

--
Mary Sauer MSFT MVP
http://office.microsoft.com/
http://msauer.mvps.org/
news://msnews.microsoft.com

"David F" <dfrench119@xxxxxxxxx> wrote in message
news:OLtlat9eIHA.4120@xxxxxxxxxxxxxxxxxxxxxxx
This is by no means a bash against MS Publisher.
I am working with a client that is assembling hundreds of reports utilizing
MS Publisher.
These are intricate financial reports with tables, graphs, charts etc. that
are many pages long, so it is by nature a very intense procedure.
The information comes mainly from Excel workbooks by way of copy and paste.
This has been an OK procedure but the fact remains that to insert a
page...redo page numbers and deal with the idiocincracies of ever changing
information have made this a nightmarish duty to say the least.

Would someone at least give me an idea if my theory is correct that MS Word
would be a better choice in this case for it's very robust nature and
ability to deal with the challenges of long documents over MS Publisher.
It has been working but there are many advantages I see that point to the
use of Word in this case.

Please make your suggestions good, bad and ugly.

David French







.

Relevant Pages

  • Re: the correct program
    ... Mary Sauer MSFT MVP ... to pull information into a Publisher page, or a Word document, which one of ... from Excel and pasting it into either Publisher or Word. ... The whole report is compiled currently in Publisher and finally sent to ...
    (microsoft.public.publisher)
  • Re: the correct program
    ... that pulls all the latest financial data. ... magic to pull information into a Publisher page, or a Word document, which ... from Excel and pasting it into either Publisher or Word. ... The whole report is compiled currently in Publisher and finally sent to ...
    (microsoft.public.publisher)
  • Re: Charts move and formatting changes when using Send to Mail Re
    ... The graphs still move. ... Choose Chart Tools, Format and click the quick launch button in the Size ... Microsoft Excel MVP ... cover other areas of the report when I use the Send to Mail Recipient. ...
    (microsoft.public.excel.charting)
  • Re: Is it possible to create Graphs and Charts?
    ... Is Publisher capable of creating graphs and charts. ... Excel doesn't give us the professional quality we are trying to achieve. ... Graphs inserted into Publisher have to be created in Excel or another graphing program. ...
    (microsoft.public.publisher)
  • Re: Simply Accounting
    ... to publisher or excel to print statements ... report, then choose "export report", then choose Excel (Publisher is ...
    (microsoft.public.excel.misc)
Loading