Courtesy of Chandoo.org, let’s all ramp up our area chart effectiveness in Excel. Area charts can give an ordinary line chart more visual impact, and with these techniques, the charts can become even more information rich, leading to greater insights. After all, isn’t that the key to a good data visualization?
First you examine and analyze your data to determine where to create your segments. Then format it this way in Excel to generate your area chart.
Click on either of the images above to read Chandoo’s discussion. He even gives us a preformatted sample that we can practice with. To get the sample click here.