PC Review


Reply
Thread Tools Rate Thread

Charting non-linear data samples on 3d surface plot

 
 
AdrianS
Guest
Posts: n/a
 
      25th Mar 2006
Hi all,

I'm trying to plot some experimental data (light intensity at different
positions and different voltages) on a 3d surface plot. However, the
voltages (series) weren't taken at constant intervals. Sample data is:

Voltage
0 1 2 2.2 2.4
-----------------------------------------------
1mm 0 0 0 0 0
2mm 0 1 2 2 3
3mm 0 2 2 2 3
4mm 0 2 3 3 4
5mm 0 3 4 4 5
6mm 0 3 4 5 5

When I try to plot this, the voltage axis plots all data at constant
intervals (presumably corresponding to the columns), regardless of the
value heading at the top of the column, whereas the gap between 1V and
2V should be 5 times larger than the gap between 2V and 2.2V.

Can anyone please tell me how to get Excel to plot this correctly?

Many thanks,
Adrian

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
3-D Surface Plot swimmingbum Microsoft Excel Misc 2 4th Sep 2008 07:13 PM
rescaling one axis in a surface plot passwd9 Microsoft Excel Discussion 2 28th Oct 2006 10:42 PM
Surface Plot Creation =?Utf-8?B?QmVuIEg=?= Microsoft Excel Programming 4 17th Jul 2006 02:09 PM
How do I plot multiple 3D surface charts =?Utf-8?B?RGF2aWQgaW4gSmFrYXJ0YQ==?= Microsoft Excel Charting 1 13th Feb 2006 12:11 PM
3D Surface Charting =?Utf-8?B?bGpsZXZlbmQ=?= Microsoft VB .NET 3 14th Feb 2005 01:15 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:01 AM.