原case
1st-case
1st-實績OK1
1st-實績OK2
1st-實績NG1
1st-實績NG2
1st-實績Block1
1st-實績Block2
1st-總case數(shù)
1st-實績
1st-進度率
1st-未實施
1st-NG
1st-Block
拉數(shù)據(jù)
通過Exce的【數(shù)據(jù)選項卡】→ 【數(shù)據(jù)取得】→ 從文件 → 從Book，將1st case的內(nèi)容整個拽過來
數(shù)據(jù)集計
1st
case集計
實績OK
實績NG
實績Block
預計(累計)1
預計(累計)2
實績(累計)1
實績(累計)2
實績(累計)1-OK
實績(累計)2-OK
對總數(shù)1
對總數(shù)2
對總數(shù)1-OK
對總數(shù)2-OK
對預計數(shù)1
對預計數(shù)2
對預計數(shù)1-OK
對預計數(shù)2-OK
Defect_List
案件發(fā)生數(shù)1
案件發(fā)生數(shù)2
案件close數(shù)1
案件close數(shù)2
案件發(fā)生累計數(shù)1
案件發(fā)生累計數(shù)2
案件close累計數(shù)1
案件close累計數(shù)2
生成圖表
進度總覽
圖表種類變更
橫軸只顯示工作日
右鍵點擊橫軸，選擇【橫軸的書式設(shè)定】
橫軸只顯示工作日1
選擇text軸
橫軸只顯示工作日2
案件總覽
Defect_List
1st Critical
1st Medium
2nd Critical
案件解消情況
數(shù)據(jù)選擇1
數(shù)據(jù)選擇2
點擊橫(項目)軸label的編輯鍵后寫入：
={"Critical","Status","","Medium","Status","","Low","Status"}
就能按照現(xiàn)在途中那樣顯示了
