|
||
|
Golden Member
 
加入日期: Apr 2002 您的住址: 台灣屏東
文章: 2,563
|
引用:
謝謝你花時間幫忙做了範例~~ 我昨天晚上自己有想要按照 leo 說的方式作作看 可是可能因為不熟悉Excel 吧，弄到晚上2點還弄不出來 所以最後就放棄了....  不好意思我沒有把條件說明清楚，看起來要畫那個 bar graph 還真的不簡單 再次感謝您的幫忙
__________________
Money It can buy a House ,But not a Home It can buy a Bed,But not Sleep It can buy a Clock,But not Time It can buy you a Book,But not Knowledge It can buy you a Position,But not Respect It can buy you Medicine,But not Health It can buy you Blood,But not Life So you see money isn't everything. I tell you all this because I am your Friend, and as your Friend I want to take away your pain and suffering..... so send me all your money and I will suffer for you. A truer Friend than me you will never find. CASH ONLY PLEASE 
|
||||||||
2016-08-02, 02:45 PM
#11
|
|
|
Senior Member
加入日期: Jun 2002
文章: 1,464
|
如果目的只是一眼看出有問題的數值且不一定需要barplot的話
可以直接用"設定格式化條件"的三色色階來達成 |
||
|
2016-08-02, 07:10 PM
#12
|
|
|
Major Member
加入日期: Jan 2002
文章: 227
|
大概是這樣...
此文章於 2016-08-02 09:58 PM 被 azopper 編輯. |
|
2016-08-02, 09:56 PM
#13
|
|
|
Advance Member
  加入日期: Dec 2002
文章: 441
|
個人作法類似 azopper ，參考原po第二張圖，簡單用格式化條件作，圖形分三區，每區10格
|
|
2016-08-02, 10:27 PM
#14
|
|
|
Amateur Member
 加入日期: Jan 2013
文章: 35
|
az開頭的都這麼強嗎
 |
|
2016-08-02, 10:50 PM
#15
|
|
|
Golden Member
加入日期: Apr 2002 您的住址: 台灣屏東
文章: 2,563
|
感謝 azteq 以及 azopper 兩位強者的指點
 小弟再來研究看看，希望這次可以成功!!
__________________
Money It can buy a House ,But not a Home It can buy a Bed,But not Sleep It can buy a Clock,But not Time It can buy you a Book,But not Knowledge It can buy you a Position,But not Respect It can buy you Medicine,But not Health It can buy you Blood,But not Life So you see money isn't everything. I tell you all this because I am your Friend, and as your Friend I want to take away your pain and suffering..... so send me all your money and I will suffer for you. A truer Friend than me you will never find. CASH ONLY PLEASE
|
|
2016-08-03, 03:02 PM
#16
|
|
