Pie charts from older versions to Excel 2007 on Windows XP

[Ted Sylvio]

Hello,

We recently updated our systems to Microsoft Office 2007 and of course with
change comes problems. We have chart templates setup for much of the
reporting that we do. When I change the numbers in the data series the
corresponding fields on the chart reflect the change for the most part.
However, when I enter a - or a zero the entire chart formatting is thrown
off. I’ve tried just about everything I can think of other than recreating
the charts, which I am hoping is avoidable, but is my last option.
Thanks for any suggestions - please let me know if more detail is needed.

 

[ShaneDevenshire]

Hi Ted,

you don't seem to be getting any response. If you want to send me a sample
I will look at it.

(e-mail address removed)

 

[ShaneDevenshire]

Hi,

First thing to say is that email to
(e-mail address removed) fail from all my email programs and
sites.?

The problem here is that Excel 2007 does not support the pattern
formatting in the chart area any more.

Do you need to do this type of formatting or can you use one of the more
standard formatting options?

The reason you didn't get a response was that no one knew what you were
doing - working with one of the old black and white patterns.

Cheers,
Shane

 

[Andy Pope]

Hi Shane,

If the OPs problem is just pattern fills in xl2007 then maybe this addin
will help.
http://www.andypope.info/charts/patternfills.htm

Cheers
Andy