Error with Chart as new sheet

[shogural]

Hi there.

I have a strange problem whereby I cannot move a newly created chart to a
new sheet. I am running Microsoft Office 2007 Professional edition.

What happens is, when I create a new chart, the chart comes up in the
current worksheet. When I try the move the chart (either by hitting the move
chart button on the ribbon, or by right clicking on the chart and selecting
move chart) the chart disappears from the current worksheet and a new
worksheet (chartx) opens but is completely blank (no white background,
nothing, just a blue background like the chart is minimised or something -
which it is not).

I have tried opening a blank chart and drawing a nonsense chart also which
suggests that it isn't simply a corrupt file but an intrinsic problem with
excel.

Please help

 

[shogural]

I don't know if it's relevant but I have also added in the add-in for pattern
fills by Andy Pope

http://www.andypope.info/charts/patternfills.htm

 

[Jon Peltier]

I've heard of this problem, and I doubt Andy's add-in has any bearing on it.
Have you installed SP1?

- Jon

 

[shogural]

Yes, I have installed SP1

I've heard of this problem, and I doubt Andy's add-in has any bearing on it.
Have you installed SP1?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______

 

[Andy Pope]

Hi,

You can remove my addin and see if the functionality comes back. If it does
let me know.

Cheers
Andy