Not repeated represents em propperly even if not in order, though still with the 1 offset).
Excel x axis data series#
On the first series can see that, despite begining at 0, it's being represented starting at 1, so all the graphic is offseted.Īlso have added at the end of the series some extra values with same X value, but instead of representing the step between values in same position, adds them after, not caring for the X value, but just for the count of values (only if repeated values, if The chart has 8 series, 4 sets with 2 series.Ĭolumnd E is X value for both the series with C and D on Y value. Note that there are many other formatting options that you might need to modify in order to get the appearance that you want.Ĭurrently am in the same situation, with excel switching values starting from 0 for the X axis and haven't seen/found a solution in months of looking around. That is just a default formatting choice, just as Excel usually defaults to General for numeric cells and displays up to 9 or 10 significant digits, depending on the cell width.įor the chart, the remedy is to modify the format.įor example, right-click the x-axis (numbers 0 to 4), click Format Axis, and change Minimum and Maximum by clicking Fixed (instead of Auto) and filling in the values that you want, perhaps 1.5 and 3.5. And it did extend the y-axis from 0 to 18, beyond my y-values of 9.5 to 15.5. The only data are the 5 y-values associated with the 5 x-values that I highlighted in A2:B6.īut Excel did extend the x-axis from 0 to 4. Excel, in particular, is not even remotely easy. Even though most people claim that they are proficient in Office, that is far from the truth. I suspect that you mean something like the following:Įxcel did not really "add data to the x-axis". Nowadays, nearly everyone uses Microsoft Office daily. Even better, the URL of an example Excel file uploaded to a file-sharing website. Here you can change the interval of tick marks, thus changing the spacing in your chart.When you have a question like that, it behooves you to provide an example in some form.
Click on Axis Options >Values in reverse order, to change how categories are numbered.Next, select Format Selection, it’s located just under File near the top of the screen.Then, click on Format from the list at the top of the screen.Open the Excel file containing the chart you want to change.Follow the steps to make additional X-Axis changes:
Excel x axis data how to#
We also mentioned other changes, and here is how to make them. Click on OK once again to exit the Select Data Source window.Finally, click the OK button, and the values will be replaced with your selection.When you select all the desired cells, tap on Select Range once more to confirm.Mark the cells in Excel, which you want to replace the values in the current X-axis of your graph.Select Edit right below the Horizontal Axis Labels tab.That will allow you to edit the X-axis specifically. Right-click the X-axis in the chart you want to change.Open the Excel file with the chart you want to adjust.
0 kommentar(er)
