5 Exciting (and awesome) line charts in PowerPoint

I’m always on the lookout for new ways to show data visually.  When you can see the problem data at a glance, it’s easier to to tell your story and convince people to help you / invest / solve the problem.  Here are five charts that IMHO are very visual.  They’re visual in that out of specification points, high and low points, etc. are highlighted and easy to see.

They’re created by

  • Combining line charts with column charts / area charts
  • Using calculations to calculate when values are out of specification and plotting these points as a new series (using #N/A)
  • Using data labels on specific data points
  • Using minus 100% percentage error bars to create vertical arrows

I’ll be posting the how to do these over the next couple of weeks, but you can download these 5 visual line charts and see if you can work it out for yourselves.

Hope it helps

+Alesandra Blakeston

Advertisements

4 thoughts on “5 Exciting (and awesome) line charts in PowerPoint

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