My x-axis for an Excel graph is missing some labels and I cannot figure out why.

More specifically, my x-axis is supposed to look like this (I will bold some of them so it's easier to read):

50, 100, 150, ..., 500, 50, 100, 150, ..., 500,50, 100, 150, ..., 500, 50, 100, 150, ..., 500,50, 100, 150, ..., 500, 50, 100, 150, ..., 500,50, 100, 150, ..., 500, 50, 100, 150, ..., 500

Instead, it looks like this:

50, 100, 150, ..., 450, 50, 100, 150, ..., 450,50, 100, 150, ..., 450, 50, 100, 150, ..., 450,50, 100, 150, ..., 450, 50, 100, 150, ..., 450,50, 100, 150, ..., 450, 50, 100, 150, ..., 450

So it skips the number 500. I made sure that the label 500 was checked in the category filter so it would appear on the graph. I also searched online but cannot find a solution. Any help would be appreciated.

The graph shows the percentage improvement for 80 different cases. (The percentage improvement is the y-axis and the 80 different cases are on the x-axis).

The reason why I have 50, ..., 500 repeated 8 times is because I'm looking at 8 different scenarios for the cases 50, ... , 500. (So we have 8*10 = 80 different cases in total.)

To create the chart, set up data like this in the worksheet:

X | Y |
---|---|

50 | 51.61440739 |

100 | 105.2234802 |

150 | 153.4851506 |

︙ | ︙ |

** where the data in the X column are formatted as text.**
Then create a Line chart, using defaults throughout.

**Below is a screenshot of how the label 500 is checked:**