XY charts not displaying correctly in Excel 2007
 

I have a suite of Excel spreadsheets for the design of reinforced concrete
that have been developed in Excel 2003.
When loaded by Excel 2007, the numerous XY charts are not displaying
correctly when series ranges are separated by commas (for example
C21:W21,C36:W36). Only the part of the series before the first comma displays.

When a very similar problem occurred some years ago with the release of a
new version of Excel, MS prepared a fix/upgrade.
--
Rod Webster FIStructE of Concrete Innovation & Design

XY charts not displaying correctly in Excel 2007
 

The problem seems to have been fixed by Excel 2007 SP2.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



RodW wrote:
I have a suite of Excel spreadsheets for the design of reinforced concrete
that have been developed in Excel 2003.
When loaded by Excel 2007, the numerous XY charts are not displaying
correctly when series ranges are separated by commas (for example
C21:W21,C36:W36). Only the part of the series before the first comma displays.

When a very similar problem occurred some years ago with the release of a
new version of Excel, MS prepared a fix/upgrade.