| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
3d shading
You can run the following in VBA (Alt+F11, then Ctrl+G):
ActiveChart.ChartGroups(1).Has3DShading = False Alternatively, you can format each legend entry (band), and apply the "Flat" material on the 3-D Format tab. You can then save this as a new template for future charts. -- Thanks, Christopher This posting is provided "AS IS" with no warranties, and confers no rights. "Suzanne" wrote: I have the newest version of excel (trial version), how do you turn off the 3d shading in a surface chart? I have searched and searched and cannot find any answers or functions to do so. I need to make plain ol' gradient surface charts, but they all automatically have 3d shading. Help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Shading every other row | Excel Discussion (Misc queries) | |||
| Shading Cells | Excel Discussion (Misc queries) | |||
| Row Shading | Excel Discussion (Misc queries) | |||
| Conditional Cell Shading (based on the shading of other cells) | Excel Worksheet Functions | |||
| shading a rowwhen a time is entered but no shading when 0 is enter | Excel Worksheet Functions | |||
![Christopher Scott [MSFT] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
