- #Scale xaxis in excel scatter chart excel 2016 how to
- #Scale xaxis in excel scatter chart excel 2016 password
#Scale xaxis in excel scatter chart excel 2016 password
#Scale xaxis in excel scatter chart excel 2016 how to
In this article, I introduce the way for how to show the date and time on X axis correctly in the Chart.
Then right click on the line in the chart to select Format Data Series from the context menu. Select the data you use, and click Insert > Insert Line & Area Chart > Line with Markers to select a line chart. 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.ĭisplay text labels in X-axis of scatter chartĪctually, 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.ġ. How to display text labels in the X-axis of scatter chart in Excel?