3D Surface -- Y axis values

[RVince]

Can someone please tell me how I can put in the Y axis values for a 3D
Surface chart? A means via VBA perhaps? Thanks, R. Vince

 

[Jon Peltier]

This article may help you understand surface charts:

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=447

- Jon

 

[RVince]

Thanks, but what does this have to do with my question? It speaks of these
charts in fairly general terms -- am I missing something here in that I
don;t see how it answers what I am asking. -R. Vince

 

[Mike Middleton]

RVince -

Your question was "how I can put in the Y axis values for a 3D Surface
chart?"

Jon Peltier's article shows "Y values or labels in the left column."

That seems to me to be an answer to your question.

- Mike
http://www.MikeMiddleton.com

 

[Del Cotter]

Your question was "how I can put in the Y axis values for a 3D Surface
chart?"

Jon Peltier's article shows "Y values or labels in the left column."

That seems to me to be an answer to your question.

I could be wrong, but I think what the poster really wants is "Arbitrary
axis scale" abilities like this:

http://peltiertech.com/Excel/Charts/ArbitraryAxis.html

but with 3D surface charts. Sadly, the tricks used to "put in" the y
axis values only work with 2D charts, because you can mix chart types,
allowing you to create an XY range that you can format as invisible with
the labels visible. Because 3D charts can never be mixed with any other
kind of chart, that technique is unavailable.

Have I got that right?

Derek

 

[RVince]

Evidently. Thanks for all your help everyone! -R. Vince