Excel 2007 chart 6th series not displaying correctly

[jmhopper]

Hello, I have a weird problem with my Excel chart. Series 1 - 3 is a bar chart on the primary axis. Series 4 - 6 is a line graph on the secondary axis of the same chart. Problem with series 6, is if I select secondary axis (what I want), the values plotted are the SUM of Series 5 + 6. If I select primary axis for series 6, I get values plotted for Series 4 + 6. I don't have any problems with series 1 - 5. Can anyone help? I'm going crazy over this... Thanks!

 

[Steve=True]

Can you post a file? I would like to help.

http://www.4shared.com/

 

[jmhopper]

The problem seems to be fixed in Excel 2010, as I have Excel 2010 at home vs. Excel 2007 at work, and the problem occurred at work with 2007. But I e-mailed the file to home and there was no problem with the charts or switching axes when I opened the Excel 2007-created chart in Excel 2010. I saved it in Excel 2010, then sent it back to my work account and the chart appeared correctly in Excel 2007 next time when I got back to the office. What a relief!

I do still have a copy of the 'bad' file at work if you're still interested in taking a look at it. There may be some 'hot fix' for this 2007 glitch that my IT folks haven't loaded onto our work servers, is a possibility. But if you do want to see the flawed chart, I could upload it tomorrow night if needed. (My office firewalls won't let me access the file-sharing site you posted.) Thanks for your reply!