What is showing you "..."? Where are you selecting the weeks from? Is it a contiguous range, or a bunch of disconnected cells? Note that using a contiguous range is always going to be easier to work with and more reliable than separate cells.
I have two sheets...in Sheet1 is my data so I have 52 weeks across from C2 - BB2. In Sheet2 is my graphs. When I right click on a graph and select "Select Data" the Select Data Source box shows up. In the left box "Horizontal Category Axis Label" is where my 52 weeks are. When I scroll down to uncheck the weeks I do not want to show. it only goes to 50 then after 50 there are 3 dots that show "..." so it will not show week 51 and week 52 to uncheck them from showing
If you click on the filter icon floating to the right of the chart, all of the categories will be available for you to select/unselect.
Alternatively, if you put your data in a range with week numbers in the first column and values in the next, and convert the range into a table (Ribbon: insert tab > Table), you will be able to filter the table, and all items in a column (up to 10,000 I believe) will be available to select/unselect. Any hidden rows in the table will not be shown in the chart.
Your awesome!!!! thank you
Often there is a need to change the data labels in your Excel 2016 graph. The procedure is a little different from the previous versions of Excel 2016. You will add corresponding data in the same table to create the label. You can also create a new set of data to populate the labels. Be more efficent and accomplish more with Excel Beginner to Advance Course up to 90% discount from this link. 1. Select the Chart that you have created and navigate to the Axis you want to change. 2. Right-click the axis you want to change and navigate to Select Data and the Select Data Source window will pop up, click Edit 3. The Edit Series window will open up, then you can select a series of data that you would like to change. 4. Click Ok For a time series like months, when you click select data you will not have the option to directly edit the x-axis. However, you still can by simply clicking Edit Legend Series and choosing X values. However, if you graph is chronological or time series based you need to pick a complementary chronological data. For categorical data, you don’t need to worry about this. Also, you can directly change x values from Select Data Source window. But essentially the steps are the same.  Create a graph. From the image below, you can see that this graph is based on the index column and the Selected Period column. Our goal is to replace the X axis with data from Date Column. Right-click the graph to options to format the graph. In the options window, navigate to Select Data to change the label axis data. Once you choose Select Data, an Edit Series window will open with information on the axis. Our goal is to change the x-axis so that you can delete the x values and replace them with the new values. If you have chronological data, you can directly access the labels. Once, you add the new data and click OK, you will be able to see the update labels reflecting the new data. |
Excel Select Data Source horizontal Axis Labels
zusammenhängende Posts
Urheberrechte © © 2024 frojeostern Inc.
