posting Excel graph results?

[AndrewT]

I want to post an attachment that raw is 400k and Zipped is 117k.

The MSexcel spreadsheet results are plotted on a log/log graph and I have used WinRAR and 7-zip to compress other files in the past.

I tried extra compression in 7-zip and it got down to 97k and allowed me to post the attachment. But, Winzip cannot open the file due to compression method 9 being used.

What do I need to do?

[BWRX]

If you just want to post the chart/graph, click on the chart/graph in your workbook, go to save as a webpage, and select the chart option. Excel will automatically export your charts to gif image files. You can then manipulate them or post them directly if they're the proper size (resolution and byte wise).

[AndrewT]

Richie boy said

Something is wrong Andrew. It should resemble what the screengrab was, and all versions of Paint I have used can save as PNG. Hmmm then again, are you on Win98 or something?

well I'm on Win98.

Bwrx,
I will try your suggestion, but my edit has expired= new post.
Just tried it.
No webpage option but there is a save as HTML option. Gone through the wizard and after about 4 pages (Finish) it came back with the wizard could not export the chart . The GIF filter etc.

[BWRX]

Taking a screenshot (and editing if necessary) works too. The gif images Excel exports are good quality. I did forget to mention to create a new folder and save into that since Excel will create another folder in that directory to store the images.

Edit: which version of Excel do you have? I know the Save as web page option is in the Office 2003 suite. It might not be in previous versions.

[AndrewT]

Hi,
Office 97
I cannot see "export" or "screenshot".
Are these called something else?

[Geoff]

Andrew

A) What format (file extension) is your 400kB file?

B) Another option would be to display the graph on your screen as you wish it to appear and then copy it to the clipboard using the 'prt scr' key on your keyboard. Open a graphics program (Irfanview is very good, and free ) then paste from the clipboard. Crop any unwanted parts of the screen dump (toolbars etc), resize if necessary before saving in a format of your choice (.gif, .png or whatever). This is what I do to obtain the 'overview' pictures of pcbs which you may have seen in one or two threads.

[lineup]

Originally posted by AndrewT

I want to post an attachment that raw is 400k and Zipped is 117k.

The MSexcel spreadsheet results are plotted on a log/log graph and I have used WinRAR and 7-zip to compress other files in the past.

I tried extra compression in 7-zip and it got down to 97k and allowed me to post the attachment. But, Winzip cannot open the file due to compression method 9 being used.

What do I need to do?

www.openoffice.org
freeware 94 Mbyte download
is said to open most any Windows Office / Word document
and you may be able to export / publish in other more internet suitable formats

Otherwise there is a Free XLS reader to download.
From which you can EXPORT, for example as .jbmp or other images.

Excel Viewer 2003
is a free .xls reader.
I have used it for exporting into other formats
Download:
http://www.microsoft.com/downloads/d...displaylang=en

[andy_c]

If all that matters is the graph and not the data behind it, then screen capture works nicely. I use the freeware IrfanView from irfanview.com. It has screen capture that works as follows.

Open IrfanView and choose Options, Capture/Screenshot. You'll see from the dialog that the capture operation will be assigned to Ctrl-F11. I choose the "Foreground Window Client Area" option, along with "Show captured image in viewer". Then click the Start button. Go to Excel and display the graph. Press Ctrl-F11 to capture. You'll see the captured window inside the IrfanView client window. This can be confusing as it will look just like the app window you've captured. To crop the image to just the graph area you want to show, drag the mouse over the desired graph area, forming a rectangle around it. Choose Edit, crop selection. Then save the image. I usually use PNG, which is an open-source standard format that's supported directly in this forum. PNG and GIF are best for cartoon-like images such as graphs. JPG will give inferior results with graphs, but is much more efficient for pictures.

[lineup]

Originally posted by lineup

www.openoffice.org
freeware 94 Mbyte download
is said to open most any Windows Office / Word document
and you may be able to export / publish in other more internet suitable formats
.

I did, myself, install latest www.openoffice.org freeware program
Latest version 2.1 for Windows.

1. A first tryout with using 'Create Presentation' wizard

2. I did export this presentation in PDF format.
It looks just great!

3. Then I did export this presentation first-present1
as a .png image
See my attachment for the result


Notice that this attached .PNG ( portable net graphic )
is compressed downto only 10 kB = 10.199 bytes ...


lineup - is really impressed ..what can be done in an easy way ..... ........ and it took me only a couple of minutes

[AndrewT]

Hi,
thanks for all the suggestions.
Openoffice & excel viewer cannot work with my old operating system (win98) and Office 97.

Will try Irfan next.

Geoff,
don't know what extn Excel uses for copy of the spreadsheet graph. After I have pasted it into wordpad or word it appears as .doc and then zips correctly as .zip and opens with Winzip or 7-zip or Winrar.