Is there a way to increment date labels by the start of every month in an excel chart?
是否有一种方法可以在每个月开始之前在excel表格中增加日期标签?
i.e. Axis values should start in DD/MM/YY: 1/1/16, 1/2/16, 1/3/16....
例如轴值应该在DD / MM / YY:1/1/16,1/2/16,1/3/16 ....
2 个解决方案
#1
1
It depends on the type of chart you use. In line and column charts, you can set the X axis to a date axis and let the major unit be 1 Month.
这取决于您使用的图表的类型。在行和列图表中,您可以将X轴设置为日期轴,并让主单元为1个月。
XY Scatter chart work differently. Here you will need to hide the X axis labels and use a data series to place the markers and add data labels, then format the series to no line and no markers. In the screenshot the series is still visible.
XY散点图的工作方式不同。在这里,您将需要隐藏X轴标签,并使用数据系列放置标记并添加数据标签,然后将该系列格式化为无行无标记。在截图中,这个系列仍然可见。
#2
0
Right click the dates on the x-axis and select "format axis".
右击x轴上的日期,选择“格式轴”。
Under "Axis Options" you can make the major unit 'fixed' at 1 month. It will then increment by the 1st of each month.
Setting a "minimum" date, will allow for setting the day which it starts (eg, if you wanted it to increment on the 3rd of each month, input 3-Jan-2016. I think the default is the first date in the data set.).
在“轴心选项”下,你可以使主要单位在一个月“固定”。然后在每个月的第一天增加。设置一个“最小”日期,将允许设置它开始的日期(例如,如果您希望它在每个月的3日增加,输入2016年1月3日。我认为默认是数据集中的第一个日期。
Make sure the category is set to "date" if excel doesn't recognise your date column. "format axis" -> "number" tab, or 'right click' -> 'format cells'.
如果excel无法识别您的日期列,请确保类别设置为“date”。“格式轴”->“数字”标签,或“右击”->“格式单元格”。
#1
1
It depends on the type of chart you use. In line and column charts, you can set the X axis to a date axis and let the major unit be 1 Month.
这取决于您使用的图表的类型。在行和列图表中,您可以将X轴设置为日期轴,并让主单元为1个月。
XY Scatter chart work differently. Here you will need to hide the X axis labels and use a data series to place the markers and add data labels, then format the series to no line and no markers. In the screenshot the series is still visible.
XY散点图的工作方式不同。在这里,您将需要隐藏X轴标签,并使用数据系列放置标记并添加数据标签,然后将该系列格式化为无行无标记。在截图中,这个系列仍然可见。
#2
0
Right click the dates on the x-axis and select "format axis".
右击x轴上的日期,选择“格式轴”。
Under "Axis Options" you can make the major unit 'fixed' at 1 month. It will then increment by the 1st of each month.
Setting a "minimum" date, will allow for setting the day which it starts (eg, if you wanted it to increment on the 3rd of each month, input 3-Jan-2016. I think the default is the first date in the data set.).
在“轴心选项”下,你可以使主要单位在一个月“固定”。然后在每个月的第一天增加。设置一个“最小”日期,将允许设置它开始的日期(例如,如果您希望它在每个月的3日增加,输入2016年1月3日。我认为默认是数据集中的第一个日期。
Make sure the category is set to "date" if excel doesn't recognise your date column. "format axis" -> "number" tab, or 'right click' -> 'format cells'.
如果excel无法识别您的日期列,请确保类别设置为“date”。“格式轴”->“数字”标签,或“右击”->“格式单元格”。