I have daily sales figures that I'd like to plot on a simple linegraph.
我有每天的销售数据，我想画一个简单的线条图。
I would like them to be shown in monthly buckets (i.e. if I sold 5€ on Jan 01 and 10€ on Jan 24, I would like to see only one data point for January with 15€ in it).
我希望他们在每月桶(即如果我卖5在1月01和10€€1月24日,我只希望看到一个数据点为1月15€)。
Please note that I don't want to use any supporting formula/VBA script, I want to do this using only chart formatting.
请注意，我不想使用任何支持公式/VBA脚本，我只想使用图表格式。
I tried setting the chart's X-axis type to "date axis" and I chose "months" as the base unit. This almost works, but the line graph ends up being kind of weird. Changing the chart type to histogram doesn't help much either. The individual sales are not "piled up" like I would but, instead, they're hidden one behind the other. Stacked histogram doesn't work either.
我尝试将图表的x轴类型设置为“日期轴”，我选择“月”作为基本单位。这几乎是可行的，但是线形图最后有点奇怪。将图表类型更改为直方图也没有多大帮助。个人销售不是像我想的那样“堆积”起来，而是藏在另一个后面。堆叠直方图也不起作用。
Any clue on how I can force excel to bucketize my data using only chart formatting? This can't be that hard...
关于如何使用图表格式强制excel对数据进行嵌套，有什么线索吗?这不可能那么难……
2 个解决方案
#1
15
Try creating a pivot chart, then grouping the dates by month (right-click a date in the pivot table, and click "Group by... Month".
尝试创建一个数据透视表，然后按月对日期进行分组(在数据透视表中右键单击一个日期，然后单击“Group by…”月”。
#2
2
If you want to group by Years as well - hold down the Ctrl Key whilst you select the Month (both categories will then show up)
如果你想按年份分组，按下Ctrl键，同时选择一个月(这两个类别将会出现)
#1
15
Try creating a pivot chart, then grouping the dates by month (right-click a date in the pivot table, and click "Group by... Month".
尝试创建一个数据透视表，然后按月对日期进行分组(在数据透视表中右键单击一个日期，然后单击“Group by…”月”。
#2
2
If you want to group by Years as well - hold down the Ctrl Key whilst you select the Month (both categories will then show up)
如果你想按年份分组，按下Ctrl键，同时选择一个月(这两个类别将会出现)