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? |
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 |
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 |
All times are GMT +1. The time now is 07:39 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com