Re: Plotting data with Excel



"Rune Allnor" <allnor@xxxxxxxxxxxx> wrote in message
news:1138722531.640861.235120@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Hi there.
>
<snip>
>
> What I want to know is if it is possible at all to have excel do
> something like IMAGESC in matlab. That is, take a NxM
> matrix and make an image where the color of pixel (n,m)
> is somehow related to the numerical value in cell (n,m).
>
> The data consist of N time series, each M samples long.
> I want to plot them either as intensity-coded images, or
> as vertical traces, "waterfall transposed" so to speak.
>
> Any suggestions and comments are appreciated.
>
> Rune

Hi Rune,
I would just write a quick BMP file utility to take your raw data and
generate an un-compressed windows bitmap file. With a command line interface
for parameters (N and M, for example) or with that info embedded in a header
to your raw data files, the actual data-to-bmp code is trivial. Customer
could then use windows paint or some such to view it. The nice thing about
BMP is it supports un-compressed images so you don't even have to do RLE of
LZW, just construct the header and spit out the pixels (with whatever
data-to-color algorithm you want). Google "BMP file format".

Bob


.



Relevant Pages

  • Re: Question(s) regarding development of proprietary FITS manipulation software. . .
    ... All 3 programs display clearly visible images. ... I've got my program parsing out the header data just fine. ... mandatory keywords which appear in ANY header ... by sub-type I mean here the various kinds of extensions: ...
    (sci.astro.fits)
  • Re: HP Mobile printing : System.MissingMethodException exception
    ... OPTIONAL HEADER VALUES ... 400 file pointer to raw data ... 60000020 flags ... >> Copyright Microsoft Corporation. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Using a PDF to create a letterhead
    ... Separate your images for top and bottom. ... Put these in the first-page header ... into a header or footer; ... Letterhead Tips and Instructions ...
    (microsoft.public.word.pagelayout)
  • Re: URL to image illustrating parenthesisfobia?
    ... useless-looking right-hand navbar, header, and footer. ... with no images and no apparent links to images. ... you see and ignore links like that all the time even if they're NOT hidden in the heading mixed in with non-page-specific stuff. ...
    (comp.lang.lisp)
  • Re: Active sort / Copy
    ... After you filter the data, you can look at how many visible rows are in the ... I'm only using columns A-F on each page of raw data. ... I then add a sheet for each of the 30 devices and then copy the header from ...
    (microsoft.public.excel.programming)