Search This Blog

Wednesday, December 19, 2018

Create an X Y Scatter Chart with Data Labels

How to create an X Y Scatter Chart with Data Label. There isn't a function to do it explicitly in Excel, but it can be done with a macro. The Microsoft Knowledge base article describes it. See the link to the article (along with the Macro code) at


  1. Doug
    I use your original invoice but sometimes the formulas get deleted.

    Do you have an updated version with an improved material database lookup and a way to lock in formulas so they are not removed ?

  2. It will be great if you provide end result excel file to download.