monirg
Well-known Member
- Joined
- Jan 11, 2005
- Messages
- 629
Does anyone know how to construct a 2D Vector Plot and / or a 2D Contour Chart, in Excel ??
These 2 chart types used to be available in almost all plotting software!! Why not in Excel ?
In a 2D VECTOR Plot: You have the data tabulated as:
(X,Y,V,theta), where V is the value at point (X,Y) and at theta degrees from the X-axis.
In a 2D CONTOUR Chart: You have the data tabulated as:
(X,Y,V), where V is the value at (X,Y). By specifying the desired highest and lowest values of V to be plotted, and the number of desired contour levels to appear, you would get a group of contour curves each at a constant value of V.
Thanks.
These 2 chart types used to be available in almost all plotting software!! Why not in Excel ?
In a 2D VECTOR Plot: You have the data tabulated as:
(X,Y,V,theta), where V is the value at point (X,Y) and at theta degrees from the X-axis.
In a 2D CONTOUR Chart: You have the data tabulated as:
(X,Y,V), where V is the value at (X,Y). By specifying the desired highest and lowest values of V to be plotted, and the number of desired contour levels to appear, you would get a group of contour curves each at a constant value of V.
Thanks.