There appears to be a bug in Office 2007 SP2 charting. This problem is reminiscent of one that existed in the initial release of Office 2007 but was fixed by a private hotfix (ie one only distributed if you specifically requested it) but was apparently also included in SP1.
The issue relates to charts with 2 y axes, containing 2 (or more) series, when the limits on the y axes are set manually (I am not sure how relevant the limits are, or the number of series etc). In my examples, I have two series, each with approximately 4000 data points, and two y axes on a line plot with a time category x axis (the same problem occurs when plotting the data as a scatter chart). This is a very modest data set and should be trivial of Excel to cope with but instead the program goes off in to a hissy fit whenever I try selecting the chart or changing it or anything!!! The same is true of PowerPoint when pasting the chart...
Some more information:
· the data (arranged in columns) has already been reduced to values (not formulae, not links to other sheets or workbooks).
· the problem is reproducible on different pc's running Office 2007 SP2 (under XP and under Vista)
· the problem disappears when restoring my system to an old state (from an image I took of my system about 6 months ago) but reappears when I install Office 2007 SP2 over this image
· the problem causes intolerable delays and poor performance!
Does anybody have any suggestions or possible a cure? Is there anyway I can submit my (very simple) workbook to illustrate the problem. Can anyone help?? (I have had the suggestion, from a member of the Excel Charts Microsoft newsgroup, that inserting a blank row just above the data has helped them but this did not cure the problem for me.)
Any help or suggestions would be really welcome.
Many thanks and best wishes, Boris.