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

This article may help you understand surface charts:

http://pubs.logicalexpressions.com/P...cle.asp?ID=447

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"RVince" <r vince 9 9 at hotmail dot com wrote in message
...
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

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

"Jon Peltier" wrote in message
...
This article may help you understand surface charts:

http://pubs.logicalexpressions.com/P...cle.asp?ID=447

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"RVince" <r vince 9 9 at hotmail dot com wrote in message
...
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

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

"RVince" <r vince 9 9 at hotmail dot com wrote in message
...
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

"Jon Peltier" wrote in message
...
This article may help you understand surface charts:

http://pubs.logicalexpressions.com/P...cle.asp?ID=447

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"RVince" <r vince 9 9 at hotmail dot com wrote in message
...
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

On Mon, 20 Aug 2007, in microsoft.public.excel.charting,
Mike Middleton said:
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
--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

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

"Del Cotter" wrote in message
...
On Mon, 20 Aug 2007, in microsoft.public.excel.charting,
Mike Middleton said:
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
--
Del Cotter
NB Personal replies to this post will send email to
,
which goes to a spam folder-- please send your email to del3 instead.