How to make an incredible area chart

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.

signature2

 

Leave a comment

Filed under Uncategorized

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s