1. New a worksheet and add one more column. Fill Column A with row numbers, Column B and C with random numbers.

2. Highlight Col(B) & Col(C), make a lollipop plot.

3. Open Plot Details dialog and go to Label tab. Enable Label, set Numeric Display Format as E.0 for both plot and click OK.

==> Some Labels does not show outside end of plot.