Excel 2007 Legend Key Problem
 

Hi, I currently have a bunch of files with stacked bar charts that were
created in Office XP. I have 3 series in each but only need to display 2.
When I add the legend and manually delete the third series it appears fine.
However, when I save the file and reopen, the legend does not appear changed
the blank series entry appears and the one I need disappears! I've been
reading and I believe this is a known bug with Excel 2007 charts. Does anyone
have a workaround? I need this ASAP so that we don't have to keep on making
changes when we publish.


Thank you