Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
rmellison
 
Posts: n/a
Default Change depth of a surface chart

How do you change the depth of a surface chart?

The only way I've been able to achieve this is by changing the chart to a 3D
bar chart, right clicking on a one of the data series, changing depth in the
options tab and then changing back to surface chart. A surface chart does not
have this option tab available, is there a better way?
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default Change depth of a surface chart

Hi,

Display the legend and then select a legend key (one of the small
squares). On the format dialog is the Options tab. Here is where the
chart depth control is buried.

Cheers
Andy

rmellison wrote:
How do you change the depth of a surface chart?

The only way I've been able to achieve this is by changing the chart to a 3D
bar chart, right clicking on a one of the data series, changing depth in the
options tab and then changing back to surface chart. A surface chart does not
have this option tab available, is there a better way?


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
  #3   Report Post  
Posted to microsoft.public.excel.charting
rmellison
 
Posts: n/a
Default Change depth of a surface chart

Thanks very much!

"Andy Pope" wrote:

Hi,

Display the legend and then select a legend key (one of the small
squares). On the format dialog is the Options tab. Here is where the
chart depth control is buried.

Cheers
Andy

rmellison wrote:
How do you change the depth of a surface chart?

The only way I've been able to achieve this is by changing the chart to a 3D
bar chart, right clicking on a one of the data series, changing depth in the
options tab and then changing back to surface chart. A surface chart does not
have this option tab available, is there a better way?


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is it possible the change the default chart formatting. Kingston999 Charts and Charting in Excel 1 January 7th 06 03:19 AM
Macro to change Chart Range when inserting a column Mark Charts and Charting in Excel 1 September 13th 05 01:12 PM
Why Does Date Format Change on Chart John Taylor Excel Discussion (Misc queries) 0 September 11th 05 08:16 AM
Bart chart with lines showing % change between elements Tom Charts and Charting in Excel 1 August 31st 05 02:01 AM
ho to change in the bubble chart the bubble position and size laszlo Charts and Charting in Excel 0 March 25th 05 05:45 PM


All times are GMT +1. The time now is 10:04 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"