PROBLEM WITH SURFACE PLOTS

S

scftw7

New Member
Joined
Sep 21, 2005
Messages
19
Hi,

I was trying to make a surface plot using data that I had retrieved. The data consisted of a 20X20 matrix set. The plot itself worked quite well, but the problem came when I wanted to specify my Y axis. The X-axis worked fine, because I found a specific option for plotting the X-axis, but there is no option to label the Y-axis. Does anyone know how to label a Y-axis on a surface plot?
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.
Sort by date Sort by votes
According to Excel, a surface chart has three axes: Category, Series, and Value. The category and series axes define the floor of the chart, and are both categorical, not numerical. The value axis is the only numerical axis of the three.

If you set up the data like this:

Code: 
   A  B  C
a  1  2  3
b  4  5  6
c  7  8  9

Excel will use the first column and first row for the category and series axis labels (one way or the other, depending whether it's plotted by rows or by columns).

More about contour and surface charts:

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=447
 
Upvote 0
You must log in or register to reply here.

Similar threads

Z
  • Question
Dynamic chart only filling half the plot area
Replies
0
Views
265
zephyrunimpressively
Z
G
  • Solved
Plotting with VBA
Replies
3
Views
203
Gitad
G
S
  • Question
Neep help setting up table for plot graph
Replies
0
Views
340
supermom28115
S
M
  • Solved
Dynamically Plot Data Points in Scatterplot
Replies
5
Views
224
felixstraube
F
O
  • Question
Creating a Graph/Chart needing TWO secondary axis options for a combination of Clustered and Stacked Graph Columns
Replies
0
Views
959
OrangeJuice
O

Forum statistics

Threads
1,220,965
Messages
6,157,119
Members
451,399
Latest member
alchavar

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top