text: Title: Legend Key Text issues in chart
  Body: Hi John,
  Thanks for the quick response last time.
  With the same code I provided last time, I noticed that under LibreOffice Calc, the legend key 
  in the chart did have text that said: "Column C".
  BUT when I open the same file in Office-2007 this text in the legend Key Text portion in the charts does not appear at all, it just shows the dash and no text associated with it.
  So for example in LibreOffice I get an Legend key that shows this: [ ----- Column C ] but 
  in Excel 2007 I only see: [ ----- ](NO text in there).
  Also when I looked at my code I wondered how the code actually obtains the text to put in the Legend key of a chart. I could not figure it out.
  
  Regards,
  P
  