Reply to thread

Message: [QUOTE="Dave R., post: 2610062"] I've checked several times, and I am having this problem. I have a workbook with 12 sheets, each with it's own chart (the charts link only to the sheet they are on, if that matters). Even after formatting data labels as percentages, sometimes they revert to decimals. I used XY chart labeler to put them on, and they are linked to cells. The cells are formatted as percentage also. I've gone through and seen it doing this a few days ago, and changed them all to percentage again. Now, many of them are decimals. Any idea why this would be happening? I think a solution would be to change the linked cells to text of '29% instead of .29 as they are now, to 'force' the data label to display text, but I'd like to avoid that if possible. Thanks [/QUOTE]