Show
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. Display text labels in X-axis of scatter chart Display text labels in X-axis of scatter chartActually, 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.
Relative Articles:
No ratings yet. Be the first to rate!
I have a chart as part of a template which gets plotted based on source data. Data seem to be fine but labels in x-axis are shown as sequence of numbers 1,2,3,4,etc., instead of actual labels(these change with source data).
This tutorial will demonstrate how to change Number Values to Text in Y Axis in Excel Changing Number Values to Text in ExcelWe’ll start with the below information. This graph shows each individual rating for a product between 1 and 5. Below is the text that we would like to show for each of the ratings. Create a table like below to show the Ratings, A column with all zeros, and the name of each Add Ratings Series
3. Click on Add under Series 4. Select the Header for the Series Name 5. Select the Series Value for the Values and click OK. Format XY Series
3. Click on Combo 4. Select Graph next to XY Chart 5. Select Scatterplot 6. Select Scatterplot Series 7. Click Select Data 8. Select XY Chart Series 9. Click Edit 10. Select X Value with the 0 Values and click OK. Change Labels
4. Double click on each Y Axis line type = in the formula bar and select the cell to reference 5. Click on the Series and Change the Fill and outline to No Fill 6. Click on the Original Y Axis Series with numbers and click Delete Final Graph with Numbers Replaced by Text |