Error with parentheses in chart labels

A

abq_jenn

The series names in my chart are set to cells, some of which contain
parentheses within their text - for example: Nonconformance (Serious)

The legend incorrectly displays the name with the closing parenthesis first:
)Nonconformance (Serious

If I include the series name on the chart data, it displays correctly (which
seems to suggest a bug with the legend).

I have tried to enclose the cell values in quotes or beginning it with a
tick mark, but the error still occurs.

This occurs in both Windows Excel 2003 and Mac Excel 2004.

Any help is greatly appreciated. Thanks in advance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top