重新排列MS Excel 2016散点图的轴 [英] Re-arrange Axis of MS Excel 2016 Scatterplot
问题描述
软件:MS Excel 2016
文件:
然后我自定义了X轴，因此它仅显示月份
很遗憾，散点图(在
您的图表从自动设置的最大值/最小值的格式开始，显示十月份为最小值.我相信，如果您在选择X轴的同时在右侧的格式化窗口中向上滚动，则会看到最小值和最大值的选项.您可以将图形中的最小值设置为36892.这对应于系列中最低日期的整数值.不幸的副作用是，圆的一半延伸到小于最小值的范围时，您的圆将被切除.您还可以将最大日期设置为37256.您可以使用其他一些结束编号来得出相同的结果，但实际上它的第二天是从次年1月的12月底开始，因此可以显示12月.
现在，如果要显示每个月(与在图表上放置最大最小值无关)，请查找单位和主要"框.由于您希望显示的主要行都带有一个月的名称，因此您需要确保下一个网格行距离一个月还远.由于并非每个月的时长不相等，因此您需要使用此数字来满足您的需求.我从30岁开始，最后紧接2个1月.但是，将其提高到31，然后提示到下个月.
这里要注意的重要一点是，您实际上并没有沿X轴按月绘制图形.您实际上是在绘制自1900年1月1日以来的天数.因此，2001年1月1日是自1900年1月1日以来的36892天.excel在计算这些天，确定日期是什么，我们喜欢阅读并显示它只有我们想要的部分.因此，对于mmmm来说，这是本月的完整拼写.而且您可以看到为什么要离开31天才能到达下个月的每条网格线.更重要的是，网格线不一定是每个月的1号，因为当您在一个月(具有28、29或30天)的某个月中提前31天时，就会执行过度步进.而且这一错误在一年中变得越来越复杂.
首先尝试使用32作为主要单位步骤，然后再设置最小和最大上限.(31导致2月在我的屏幕上被跳过).您仍然应该看到轴在1月之前开始，但是您的月份应该都井井有条，全部显示出来，并且没有切圆.在轴上添加最大值和最小值会切断您的圆，但将轴限制为仅显示12个月.
Software: MS Excel 2016
Files: GitHub Repository
Referring Question: MS Excel Scatterplot converts Months to Numbers
I created scatterplot in month_unordered_axis.xlsx from following data
Then I customized X-axis so it displays only month
Unfortunately the scatterplot (in Chart1 of month_unordered_axis.xlsx) starts with October rather than January.
How to order the X-axis so it displays from January to December?
Your graph is displaying October as the minimum value from its automatic formatting of max/min values. i believe if you scroll up in that formatting window on the right while you have the X-axis selected you will see an option for min and max value. You could set this for the minimum value you in your graph to 36892. This corresponds to the integer value for you lowest date in your series. The unfortunate side effect is that half your circle will be cut off as it extends into the range that is less than your minimum value. You can also set your maximum date to 37256. There are a few other end numbers you can use to give the same results but its essentially the end of December start of January the following year that allow December to be displayed.
Now if you want every month to be displayed (which is independent of placing max min values on your graph), look for the UNITS and Major box. Since you will want ever major line displayed with the name of a month, you will need to make sure the next grid line is a month away. Since not all month are not equal in length you need to play with this number a bit to suit your needs. I started with 30 and wound up with 2 Januaries back to back. However bump it up to 31 and then it tips over into the next month.
The important thing to note here is that you are not actually graphing by months along the X-axis. You are actually plotting by the number of days since January 1st 1900. so January 1st 2001 is 36892 days since January 1st 1900. What excel is doing is counting those days, determine what the date is in a way we like to read it and displaying only the portion we want it to. So for mmmm it the full spelling of the month. And you can see why each grid line being 31 days away is needed to jump into the next month. The kicker is, the grid line is not necessarily the 1st of each month due to the over stepping that is done when you advance 31 days in a month that has 28, 29, or 30 days. and that error gets compounded through the year.
Try using 32 as theMajor Unit step first before putting min and max caps on. (31 resulted in Feb being skipped on my screen). You should still see your axis start before Jan, but your months should all be in order, all displayed and no circles being cut off. Adding the max and min to the axis will cut off your circles but limit the axis to only displaying 12 months.
这篇关于重新排列MS Excel 2016散点图的轴的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
