Look Who it Was Random video

Excel - Excel Pie Chart Label Color Bug & Possible Solutions - Episode 1147

709 views · Published 18 November 2009 · 3:47 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial - Excel Pie Chart Label Color Bug & Possible Solutions.

Welcome to another episode of the MrExcel netcast, where we tackle all your Excel questions and challenges. I'm Bill Jelen, and today we have a question from Wang that has stumped me all day. Wang has discovered something quite unusual and I have to congratulate him for his tenacity in finding this issue.

Wang's question is about data labels in a pie chart. He wanted to change the font color of one label to red, which is a cool feature not many people know about. However, when he updated the value of that label, the font color remained static and did not change with the updated value. This is because once you manually update a label, it becomes static and will not automatically update.

In Excel 2003, there was a feature called AutoFormat or AutoText that could reset the label text and fix this issue. However, in Excel 2007 and 2010, this feature is no longer available. I tried using the macro recorder to find a solution, but unfortunately, it does not work in Excel 2007 and gives incorrect code in Excel 2010.

I have reported this bug to Microsoft and hopefully, it will be fixed in future versions. In the meantime, if anyone has a solution for Wang's problem, please email me at [email protected] and we'll feature it on the podcast.

On a side note, with Thanksgiving coming up in the US, it's time to start thinking about Christmas shopping. Instead of fighting the crowds at the stores, why not ask for some great Excel books from MrExcel.com? Use the secret coupon code on the screen to get 20% off your order. Whether it's "Excel Gurus Gone Wild" or "Live Lessons VBA", we've got you covered.

Thanks for tuning in to this episode of the MrExcel netcast. Don't forget to subscribe and hit the notification bell to stay updated on all our latest Excel tips and tricks. See you next time!"

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/

Table of Contents:
(00:00) Congratulating Wang for discovering something unusual
(00:30) Creating a pie chart with data labels
(00:49) Wang's request for a label in a different color
(01:02) The issue with updating part of a label
(01:39) Solution in Excel 2003
(02:00) Attempting to find a solution in Excel 2007 and 2010
(02:41) Request for a solution from listeners
(02:51) Clicking Like really helps the algorithm

This video answers these common search terms:
Bug report for Excel 2010 macro recorder
Changing font color in Excel pie chart labels
How to create a pie chart with data labels in Excel
Issue with updating pie chart labels in Excel
Macro recorder not working in Excel 2007
Recommended Excel books: Excel Gurus Gone Wild and Live Lessons VBA
Resetting label text in Excel 2003 and 2007
Secret coupon code for 20% off Excel books at MrExcel.com
Seeking solution for changing color in Excel pie chart labels
Thank you for watching the MrExcel netcast
Thanksgiving and Christmas shopping tips
YouTube video on analyzing data with Pivot tables

Wang asks how to change part of one data label to be red. Unfortunately, the label is then broken. A macro should solve this, but it does not. Episode 1147 discusses this problem.

Join the MrExcel Message Board discussion about this video at  https://www.mrexcel.com/board/threads/1152753/

More from this channel