Perspective setting won't save in a 3-D column chart

K

Kathi

I have a 3-D column chart that has the perspective setting as 20, the
elevation as 24 degrees and the rotation as 198 degrees. I change the
settings, close the dialog box and click save. Yet the perspective setting
resets itself to 15 every time I open the file. I am using Excel 2007. Any
suggestions? Thanks.
 
S

ShaneDevenshire

Hi Kathi,

I have been able to duplicate your problem, I suggest this is a bug,
although there might be some reason for this behavior, I can't think of any.
It's probably not worth it but I suppose you could attach a macro to the
Open_Workbook event and reset it to 20 each time.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - (re-) Set a Table Style 2
Setting Wall Color in 3-D charts 1
Using Cartesian Cell Names 1
Possible? Variable X and Y data sources and Auto Charting 0
Excel 3-D Pie Chart Flaw & Test 3
3-D Column Chart 3
Cumulative Data Labels on Stacked Bar/Column Chart 1
how to change color gradients in a bar chart 0

Top