Hi Jan,

I am not sure if this is what you are asking about, but if you want to program in VBA the code that is equivalent to setting 3-D Rotation Depth (% of Base) to 130 you may use something like this:

ActiveChart.DepthPercent=150





Jr wrote:

Chart problems
01-Apr-09

I am trying to work a case problem currently with a 3D collum chart. The 2
items I am stuck on is changing the base width of the chart to 130 and Modify
the depth axis so the the values are displayed in reverse order. The problem
reads as follows:

Rotate the 3D chart using the following parameters: x-axis rotation 30 deg,
y-axis rotation 20 deg,perspective 25 deg, and base width 130. Modify the
depth axis so that the values are displayed in reversed order.

I can do it all except for what I've listed in the first paragraph.

Thanks in advance for your help!

Jan

Previous Posts In This Thread:

On Wednesday, April 01, 2009 10:45 PM
Jr wrote:

Chart problems
I am trying to work a case problem currently with a 3D collum chart. The 2
items I am stuck on is changing the base width of the chart to 130 and Modify
the depth axis so the the values are displayed in reverse order. The problem
reads as follows:

Rotate the 3D chart using the following parameters: x-axis rotation 30 deg,
y-axis rotation 20 deg,perspective 25 deg, and base width 130. Modify the
depth axis so that the values are displayed in reversed order.

I can do it all except for what I've listed in the first paragraph.

Thanks in advance for your help!

Jan


Submitted via EggHeadCafe - Software Developer Portal of Choice
WPF Datagrid as ComboBox Dropdown Part 2
http://www.eggheadcafe.com/tutorials...-combobox.aspx