Thanks again Tony,

But I am having trouble getting a surface graph to look like the cross
sectional area of a conduit. I am probably doing something wrong, or I do
not have the proper graph tools loaded. I will keep working on it.

One other thing if I may, I transfer the value of cell A1 to cell B2 by
placing =A1 in cell B2. Now, can I copy the value in cell A1 to cell B2 as
text? The reason I want to do this is because I would like to use a very big
font in cell B2 by spanning several cells. This way I don't have to stretch
B2 and all cells above and below B2 really wide.

Thanks

John

----- Original Message -----
From: "Tony Smith" <ajsmith@rivernet.com.au>
To: "Microcontroller discussion list - Public." <piclist@mit.edu>
Sent: Monday, July 11, 2005 8:12 PM
Subject: Re: [OT] Excel, graphing an array?


> > I am wondering if it is possible to graph an array in Excel?
> >
> > I want to visually display an air flow velocity profile within a
conduit.
> > If I take velocity probe readings and place them in an Excel array of
> > cells, is there a way to display this array with shades of color
> > corrosponding to the values in the array. I am thinking of an array of
> > say, 10 rows and 6 columns
> >
> > Or, is there some other way to do this?
> >
> > Thanks
> >
> > John
> > --
>
>
> Try a surface graph.  Does exactly what you are describing.
>
> Tony
>
> --
> http://www.piclist.com PIC/SX FAQ & list archive
> View/change your membership options at
> http://mailman.mit.edu/mailman/listinfo/piclist

-- 
http://www.piclist.com PIC/SX FAQ & list archive
View/change your membership options at
http://mailman.mit.edu/mailman/listinfo/piclist