OT: Plotting data with Excel

Hi there.

I am involved in a project where we want to measure some data.
My job is basically to guide the customer in choise of equipment
and experiment setup, and of analyzing the data after the
measurements are done. The customer will do the actual
measurements, for a number of practical reasons.

Now, I use matlab to plot and do QC on the data. In this
experiment I will not be around to do that, and I don't see
much point in getting the customer to buy a $2000 matlab
lisence just to make a couple of plots of the data during
measurements. So I am thinking of doing this with excel
instead.

The problem is that I haven't used excel for ages.

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

.

Relevant Pages

  • Re: OT: Plotting data with Excel
    ... My job is basically to guide the customer in choise of equipment ... I use matlab to plot and do QC on the data. ... The problem is that I haven't used excel for ages. ...
    (comp.dsp)
  • Generating data
    ... how to transfer data from matlab to excel ... Im build a GUI in Matlab, ... can I plot the data from excel then plot by ...
    (comp.soft-sys.matlab)
  • Generating data
    ... how to transfer data from matlab to excel ... Im build a GUI in Matlab, ... can I plot the data from excel then plot by ...
    (comp.soft-sys.matlab)
  • Setting Excel graph from Matlab
    ... I have a question: is is possible after exporting data (two columns: ... X and Y) to Excel to make a plot from them directly from Matlab? ...
    (comp.soft-sys.matlab)
  • Re: Major help needed - Iterative Functions
    ... If producing the final schedule cannot be automated on excel then such is ... going to retool and then compare the results to determine the best solution. ... So I have a table from which I know the products and dates the customer ...
    (microsoft.public.excel.programming)