Our Service

Pop-up Comments for Graphics in Excel

Excel is a powerful tool for data analysis and visualization. It allows users to create charts, graphs, and other visual aids to help them understand their data better. However, sometimes these graphics can be complex, and it may be challenging to convey all the necessary information in a single image. That’s where pop-up comments come in.

What are Pop-up Comments?

Pop-up comments are small text boxes that appear when you hover over a specific area of a graphic. They can contain additional information, explanations, or context that may not be immediately apparent from the graphic itself. Pop-up comments are an excellent way to add more detail to your charts and graphs without cluttering them up with too much text.

How to Add Pop-up Comments to Your Graphics

Adding pop-up comments to your graphics in Excel is relatively easy. Here’s how:

Step 1: Select the Graphic

First, select the graphic you want to add a pop-up comment to. You can do this by clicking on the graphic or chart.

Step 2: Insert a Comment

Next, right-click on the graphic and select “Insert Comment” from the drop-down menu. A small text box will appear next to the graphic.

Step 3: Add Your Comment

Type your comment into the text box. You can format the text, add links, or even insert images if necessary.

Step 4: Format the Comment

You can format the comment box by right-clicking on it and selecting “Format Comment” from the drop-down menu. Here, you can change the font, size, color, and other formatting options.

Step 5: Test the Pop-up Comment

Save your changes and test the pop-up comment by hovering over the area of the graphic where you inserted the comment. The text box should appear, displaying your comment.

Benefits of Using Pop-up Comments

Pop-up comments can be a valuable tool for anyone who needs to create complex graphics in Excel. Here are some of the benefits of using pop-up comments:

  • Clarity: Pop-up comments can help clarify complex graphics by providing additional information or context.
  • Efficiency: Pop-up comments allow you to add more detail to your graphics without cluttering them up with too much text.
  • Flexibility: Pop-up comments can be added or removed as needed, making them a flexible tool for data visualization.
  • Accessibility: Pop-up comments can make your graphics more accessible to people with visual impairments or other disabilities.


Pop-up comments are a powerful tool for anyone who needs to create complex graphics in Excel. They can help clarify your data, add context, and make your graphics more accessible. By following the simple steps outlined above, you can easily add pop-up comments to your charts and graphs and take your data visualization to the next level.


Did you find this article useful?

Share it with your friends or colleagues

About Aepoch Advisors

We are a boutique accounting and consulting firm servicing international businesses operating in China. We offers book keeping and business advisory service. We also help our clients select and implement SAAS business applications
Cloud technology significantly reduces cost foreign companies traditionally spent on tax compliance and ERP systems. Our cloud professionals can help with streamlining your management and controling structure, as well as advising you on how to reduce risks and maximize profits with software purposely built for Chinese business. Contact us today to learn more about our services.