excel chart x axis text instead of numbers. Then align the chart exactly to the. Is there a reason you want to use a scatter chart instead of a line chart (hide the line so it's just points) and you can label the axis.
excel chart x axis text instead of numbers I want the x axis to show the numbers in the 'codes'. Is there a reason you want to use a scatter chart instead of a line chart (hide the line so it's just points) and you can label the axis. When i insert a column chart, the x axis shows 1, 2, 3, 4, 5, 6.
Then Align The Chart Exactly To The.
To show text instead of the number labels on the x axis, you need to add an additional series with the values 1 to 5. Edit the chart data and check the entries for horizontal (category) axis labels. If you see numbers there instead of the desired text, click edit and select the range where.
Add This Series To The Chart (Copy The Cells With The.
I want the x axis to show the numbers in the 'codes'. The horizontal (category) axis, also known as the x axis, of a chart displays text labels instead of numeric intervals and provides fewer scaling. The y axis is showing two bars which are the code and amount.
Is There A Reason You Want To Use A Scatter Chart Instead Of A Line Chart (Hide The Line So It's Just Points) And You Can Label The Axis.
First step is to rotate all numbers and text 90ยฐ, that is possible with the settings in the chart. When i insert a column chart, the x axis shows 1, 2, 3, 4, 5, 6.