Excel图表:多数据折线图展示(复选框)
2023-12-26 本文已影响0人
王生28
图表复选框应用:
日期:=IF(ISERR(-(H$1&-ROW(H1))),"",2023&-H$1&-ROW(H1))
指标:=IF(G1=TRUE,"消费"," ")
指标数值:=IF($I$1="消费",SUMIF('日消费 '!$C:$C,H2,'日消费 '!$F:$F)," ")
图表复选框应用:
日期:=IF(ISERR(-(H$1&-ROW(H1))),"",2023&-H$1&-ROW(H1))
指标:=IF(G1=TRUE,"消费"," ")
指标数值:=IF($I$1="消费",SUMIF('日消费 '!$C:$C,H2,'日消费 '!$F:$F)," ")