☰

從電子表格產生帶有月份和類別列的折線圖？

tag-icon • tag-icon microsoft-excel worksheet-function charts
從電子表格產生帶有月份和類別列的折線圖？

嘗試產生一個折線圖來顯示每月特定類別發生的數量。此電子表格包含實例的類別及其發生的月份。簡單的方法來做到這一點？

例如

**Month **Event
January Logo
January Wedding
January Save the Date
January Save the Date
January Save the Date
January Crest
January Wedding
January Wedding Save the Date
January Wedding
January Crest for Wedding
January Wedding
January Wedding
January Wedding
January Wedding
January Logo
January Editorial
January Crest
January Wedding
January Wedding
January Wedding
January Wedding
January Calligraphy Commission
January Crest for Wedding
January Crest for Wedding
January Wedding
January Wedding
February    Calligraphy Commission
February    Illustrations
February    Wedding Save the Date
February    Certificate Fill-In
February    High End Party
February    Wedding
February    Editorial
February    High End Party
February    Wedding
February    Wedding
February    Save the Date
February    Wedding
February    Crest for Wedding
February    Wedding
February    Wedding
February    Crest

ETC。

答案1

透過使用資料透視表進行計數並使用資料透視圖進行視覺化，可以輕鬆完成此分析。

這是成品，數據與您的相似。

支點

設定資料透視表時，您將需要確定執行MONTH和群組的理想方式EVENT。根據它們是否都是行或一個是列另一個是行，可以獲得不同的圖表。上圖是兩行。主要差異在於，如果其中一個長條圖位於列上，則長條圖的顏色會有所不同。

試試看安排，直到找到你喜歡的。

相關內容