Attached is a pie chart made in Excel 2003 (I didn't make it originally) that I have to keep up each month.
The legend for the chart is located in A2:A6
The values are located in B2:B6
The values all appear to be correctly displayed in the pie.
Until this month, the legends were also correctly displayed.
However, this month, the text in A6 changed (all the rest remined the same). If you hover your mouse over the blue area that presents this text location, a tool tip will appear with the correct text it in (which is what currently resides in A6). However, the chart still displays what the text in A6 was last month, and I can not for the life of me figure out why it is not displaying what is currently in A6.
Why does the chart appear to know what should be there, but not display it?![]()




Reply With Quote