Discussion Locked

What is the best format for my report?

0 helpful
8 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a quarterly report that contains approx. 20 -25 Excel charts and about 10 pages long. The report was originally created in Word but that took forever to load and even with locking, the graphs and text boxes moved around. I recently moved it to Excel and everything is fine. Now they are talking about posting the report to the Intranet. I don't have PDF writer and I can't save the pages as HTML files in Excel. I have tried to cut and paste the pages to PowerPoint but that locks up when I try to save. I'm thinking about moving the whole thing to Access. What is the best way to handle this problem?

8 replies

by winteromeo

You may use dreamweaver or frontpage to help you load your excel file in it original format.

by dklippert

If you don't need dynamic charts, select the chart in Excel. Hold down the Shift key and click on the Edit menu.
Choose Copy Picture.
Go to Word and paste the graphic.
Do the same with each chart.
You should now be able to save the document as a web page.

by sgt_shultz

make sure you didn't get the adobe pdf printer driver with any of your scanners you might have. we got it with a visoneer scanner. it is cool, you just print your doc to it and it pdf's it. also, check out the adobe website. you can do pdf creation over the web (you would need broadband because file is big, yes?) i think you can just buy one translation at a time. for $10/month you can pdf all the stuff you want...

by irenecm

I'm more concerned with not having to reformat the report. I would like to do it at no cost if at all possible. Thanks, any way.

by amanabala

Naive question: why are you unable to save the pages as HTML in Excel? I never had an issue..

Also, without knowing the source(s) of data (manual entry into the excel sheet etc), I think it will be difficult to suggest a solution. If you could elaborate a little, may be I can help.

If your problem is already solved, please ignore this post.

-Ravi

by ehann

Look for a free program called irfanview. It is an imaging program. Take a snapshot (alt/printscreen) of each chart, one at a time, place in paint program and save as jpg (or bitmap). Go to irfanview and build a slideshow. Save slideshow as an exe and there ya have it. You will be able to build a slide show full of charts and be able to use the right and left mouse buttons (or the page up/page down) to flip the charts.
irfanview is freeware and is absolutely incredible stuff.

This discussion is closed to new replies.