'Using a pivot table and want to display all X-Axis tick labels
I am attempting to create a line graph using a pivot table to display my plot. My Y-axis values are integers but my X-axis values are strings. I have everything on the plots that I want, except one minor thing: The labels are displayed every one 6 ticks vs what I tried to do with every tick. Is the issue because they are not in direct order? Instead of 1,2,3,4,5,6,7,etc..56. They are 13,16,17,19,22...etc..56.
If I make the serial number 1 through 26, everything will be displayed.
How do I replace the 1,2,3,4,5,6,etc.. with the actual serial number? This is data being imported from an excel file
Sometimes the data will have up to 100 values and it won't bother me if they are hard to read
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|