Re: 3D Surface from data from 3 columns

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Jon Peltier (jonxlmvpNO_at_SPAMpeltiertech.com)
Date: 02/09/04 

Date: Mon, 09 Feb 2004 10:51:13 -0500

Select your data, then choose Pivot Table from the Data menu. While
defining the layout of the pivot table (different versions of Excel
handle this differently), drag the X field into the rows area of the
layout, drag the Y field into the columns area, and drag the X field
into the data area. This should produce a grid of rows and columns that
can be used as the source of a surface chart. Assuming there is a unique
Z value for each X-Y pair.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

jack wrote:
>>If you have data that would fit into a grid of rows and columns, one
>>value per grid location, no grid locations without a value, you can make
>>a surface chart in Excel. If you have X-Y-Z in columns, but the
>>requirements I just stated are met, you can use a pivot table to turn
>>your list into a grid.
>
> but how exactly should I do it?
>
>
>
> Put headers on the columns (X, Y, and Z will do),
>
>>put X in the rows field, Y in the columns field, and Z in the data
>>field. Make your surface chart from the resulting table.
>
> it is very easy but it doesn't change my XYZ into grid...:-)
>
> I am not a newbie- but I still don't know how to do it...:-)
>
>
> Jack :-)
>
>
>
>
>
>
>

Relevant Pages

  • Re: Counting unique entries based on given condition
    ... Excel 95 - Excel 2007 ... there's no "count unique" functionality in a Pivot ... in the "Count Of comp" I want only the count of Unique companies. ... Drag the Prod field here ...
    (microsoft.public.excel.misc)
  • Re: Counting unique entries based on given condition
    ... Excel 95 - Excel 2007 ... there's no "count unique" functionality in a Pivot ... in the "Count Of comp" I want only the count of Unique companies. ... Drag the Prod field here ...
    (microsoft.public.excel.misc)
  • Re: Pivot-How to add field value to already made group
    ... then group those and just drag the old group off the table. ... All of my data is in the Excel table etc. ... >> then go to the pivot table, invoke the wizard and press 'back' at the ... >> Nick Hodge ...
    (microsoft.public.excel)
  • Re: Omitting a field when using SELECT *
    ... drag the fields into the grid. ... > returns to excel. ... > all the field names in a coded query would become messy. ...
    (microsoft.public.access.queries)
  • Re: Pivot Pagefield multi-select? (Excel 2003)
    ... > NorTor ... >>If you drag that page field to a row field, make your multiselection, then drag ... >>> Using Excel 2003, is this possible? ... >>> the pivot, only 'regular' excel functionality. ...
    (microsoft.public.excel.programming)