Excel Data Selection from Select Data Source

Question

I am trying to expand the Horizontal (Category) Axis Label down so that I can uncheck a variety of different boxes, I have near 320 points however this menu will only go down to 50 boxes before showing, "..." as thought you could click and expand the box but you cannot. I don't want to use the EDIT button because it will ruin the self generating graph I have active for these data points. Does anybody know how to expand the Horizontal Axis Labels box options so I can click or unclick all the boxes I choose? Thank you so much

Answer 1

Hello,

There are a few Horizontal Axis options that you can specify such as the order in which categories are displayed, and the placement of tick marks. See if the link below helps:

Change the scale of the horizontal (category) axis in a chart

Feel free to reach out if you require further assistance.

Answer 2

Hi,

We have noticed that the post has been inactive for quite some time. We'd like to confirm if the article provided by Hector Mad resolved the issue.

If so, we highly encourage you to inform our Community by clicking on Yes or marking his post as an answer. This will help other members who may have the same issue as you. Otherwise, don't hesitate to update us so we can further assist you.

Regards.

Answer 3

The filter button that appears when you click on a chart, allows you to see more series/categories to hide/show in the chart.  This article should help...

https://support.office.com/en-us/article/Change-the-data-series-in-a-chart-30B55A30-1C2E-42D5-8ED1-3CC3FFB68036