How to display text labels in the X-axis of scatter chart in Excel?
Have you ever encountered a problem that the text labels cannot be shown correctly on the X-axis of a scatter chart as below screenshot shown? In this article, I introduce an around-way for solving this problem.
Recommended Productivity Tools for Excel
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 71% of your time and solve 82% Excel problems for you. 300+ advanced tools designed for 1500+ work scenario, make Excel much easy and increase productivity immediately.60-day Unlimited Free Trial
Actually, there is no way that can display text labels in the X-axis of scatter chart in Excel, but we can create a line chart and make it look like a scatter chart.
1. Select the data you use, and click Insert > Insert Line & Area Chart > Line with Markers to select a line chart. See screenshot:
2. Then right click on the line in the chart to select Format Data Series from the context menu. See screenshot:
3. In the Format Data Series pane, under Fill & Line tab, click Line to display the Line section, then check No line option. See screenshot:
If you are in Excel 2010 or 2007, check No line in the Line Color section.
Then only the markers are displayed in the chart which look like a scatter chart.
Add Text (add character/word to a specific location of each cell in a range.)