日期相同的数据应在Excel中添加到条形图中 [英] Data with same date should be added in bar chart in excel

问题描述

Date             Total Property Count
20/5/2011        114
20/5/2011        65
21/5/2011        21

在图形中，y轴是属性计数"，在x轴中是日期"

因此，条形图将在同一日期总计114 + 65 = 179，并为此显示单个条形..

In graph y-axis is Property count and In x-axis is Date

so bar graph will sum up 114+65 = 179 as it is in same Date and shows single bar for that..

How can i achieve this ??

推荐答案

在电子表格中添加第三列.

在该列的第一行中，添加条件公式以测试第一个单元格中的日期.将单元格拖动或复制到其余行. 图表 row 列.

它将测试日期，如果它们匹配，它将对结果求和.否则，它将开始一个新的总和.

Add a third column to the spreadsheet.

In first row of the column add a conditional formula to test the date in the first cell. Drag or copy the cell to the remaining rows. Chart that row column.

It will test the date, if they match it will sum the result. Else it will start a new sum.

=IF((A2=A1),(B2+C1),(B2))

 	   Col A	Col B		Col C
1	Date	    	Property 	Sum By Date
2	5/20/2011	114	     	114
3	5/20/2011	65	    	179
4	5/21/2011	21	     	21
5	5/21/2011	4	     	25
6	5/21/2011	45	     	70
7	5/25/2011	16	     	16

问候

这篇关于日期相同的数据应在Excel中添加到条形图中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！