posting Excel graph results? - diyAudio
Go Back   Home > Forums > General Interest > Everything Else

Everything Else Anything related to audio / video / electronics etc) BUT remember- we have many new forums where your thread may now fit! .... Parts, Equipment & Tools, Construction Tips, Software Tools......

Please consider donating to help us continue to serve you.

Ads on/off / Custom Title / More PMs / More album space / Advanced printing & mass image saving
Reply
 
Thread Tools Search this Thread
Old 14th February 2007, 03:30 PM   #1
AndrewT is offline AndrewT  Scotland
diyAudio Member
 
Join Date: Jul 2004
Location: Scottish Borders
Question posting Excel graph results?

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?
__________________
regards Andrew T.
  Reply With Quote
Old 14th February 2007, 03:34 PM   #2
BWRX is offline BWRX  United States
diyAudio Moderator Emeritus
 
Join Date: Jan 2005
Location: Pennsylvania
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).
__________________
Brian
  Reply With Quote
Old 14th February 2007, 03:50 PM   #3
AndrewT is offline AndrewT  Scotland
diyAudio Member
 
Join Date: Jul 2004
Location: Scottish Borders
Richie boy said
Quote:
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.
__________________
regards Andrew T.
  Reply With Quote
Old 14th February 2007, 03:57 PM   #4
BWRX is offline BWRX  United States
diyAudio Moderator Emeritus
 
Join Date: Jan 2005
Location: Pennsylvania
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.
__________________
Brian
  Reply With Quote
Old 14th February 2007, 04:02 PM   #5
AndrewT is offline AndrewT  Scotland
diyAudio Member
 
Join Date: Jul 2004
Location: Scottish Borders
Hi,
Office 97
I cannot see "export" or "screenshot".
Are these called something else?
__________________
regards Andrew T.
  Reply With Quote
Old 14th February 2007, 04:15 PM   #6
Geoff is offline Geoff  United Kingdom
diyAudio Member
 
Join Date: Apr 2001
Location: UK
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.
  Reply With Quote
Old 14th February 2007, 04:18 PM   #7
lineup is offline lineup  Sweden
diyAudio Member
 
lineup's Avatar
 
Join Date: Dec 2005
Location: the north
Default Re: posting Excel graph results?

Quote:
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
__________________
lineup
  Reply With Quote
Old 14th February 2007, 05:07 PM   #8
andy_c is offline andy_c  United States
Banned
 
Join Date: Apr 2003
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.
  Reply With Quote
Old 14th February 2007, 06:49 PM   #9
lineup is offline lineup  Sweden
diyAudio Member
 
lineup's Avatar
 
Join Date: Dec 2005
Location: the north
Default Re: Re: posting Excel graph results?

Quote:
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
Attached Images
File Type: png first-present1.png (10.0 KB, 122 views)
__________________
lineup
  Reply With Quote
Old 14th February 2007, 07:25 PM   #10
AndrewT is offline AndrewT  Scotland
diyAudio Member
 
Join Date: Jul 2004
Location: Scottish Borders
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.
__________________
regards Andrew T.
  Reply With Quote

Reply


Hide this!Advertise here!
Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
looking for FR graph for w3-871 kifeinthesink Multi-Way 6 7th June 2008 07:15 AM
Who can explain this FFT graph to me Bas Horneman Tubes / Valves 27 20th November 2007 02:14 PM
what is an FFT graph? keantoken Everything Else 23 10th September 2006 12:13 AM
What graph to look at? pjacobi Solid State 3 18th February 2004 01:56 AM
help interpreting graph getafix Multi-Way 6 12th October 2003 12:52 AM


New To Site? Need Help?

All times are GMT. The time now is 08:36 AM.


vBulletin Optimisation provided by vB Optimise (Pro) - vBulletin Mods & Addons Copyright © 2014 DragonByte Technologies Ltd.
Copyright 1999-2014 diyAudio

Content Relevant URLs by vBSEO 3.3.2