Format data labels in Excel chart automatically as I add data

[falseadvertise]

Some background:
I have 40 individual data points that I am plotting on a scatter plot in excel. As I add them, I am having to go, each time, and update the format of the data labels.

What i need is only a label and no data point or line to appear on the scatter plot. I want it to have a boarder and be in about 14 pt font. Right now i am putting all of the data points above the center to make room for the possibility that i have more then one data label on a single point. (Since i have only values 1-5 and 40 data points the possibility is high that this will happen). I also want to be able to leave some spaces blank (or at 0,0) so that i can add to the chart as needed.

The ultimate outcome would be that the chart automatically aligns the data labels so they are not over each other but this is not my main concern.

Is this possible in excel. I don't really see anything that gives an option for saving or repeating format.

Thanks for the help!!

 

[Steve=True]

Do do everything you want, you would need VBA programming.