Book

Suggestions


Enter your email address:

Delivered by FeedBurner


Home Page

Bloglines

1906
CelebrateStadium
2006


OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal












Subscribe here
Add to 

My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!


eXTReMe Tracker
  Web http://www.klippert.com



  Sunday, November 04, 2007 – Permalink –

Chart Art

Apple π


Look at how different media organizations have used graphics/graphs to illustrate the news.
Poynter Online:
The Art of Explanation


While Edward Tufte has concerns about representing data accurately in charts, he does, use pictures to demonstrate relationships.
(See Edward Tufte)

If you would like to try your hand, here are some links that will help to spice up your condiment report.

PC Magazine:
Add Images to Excel Projects

MacWorld:
Excel Chart Art

Andy Pope:
Dividing a graphic into sections


Excel 2007 has a great graphic look for charts, but these links still work



See all Topics

Labels:


<Doug Klippert@ 5:39 AM

Comments: Post a Comment


  Wednesday, March 28, 2007 – Permalink –

Data Scrutiny Charts

Ways to look closer



Professional statisticians typically have powerful software at their disposal to perform advanced analyses and create slick graphs. But many professionals in the quality field don't enjoy that luxury.

Faced with a limited budget, they must be resourceful with the software they already have. Besides, not everyone needs the capability to perform nonlinear regression with custom loss functions for maximum likelihood!

Fortunately, many occasional data analysts already own a versatile software capable of providing most basic quality analyses -- Microsoft Excel.

  • Shewhart control charts

  • Pareto charts

  • Simple box-and-whisker plots




Excel for Data Analysis



See all Topics

Labels:


<Doug Klippert@ 6:49 AM

Comments: Post a Comment


  Saturday, December 30, 2006 – Permalink –

Chart Null Data Gaps

Fill in the spaces



When creating a chart, data can sometimes be missing. You have a choice of leaving the cells empty or making them zero.

By default, an empty cell will leave gaps in your graph. Zero entries will send a line graph down to the base line.

One way to force Excel to interpolate the data is to enter the function =NA() in the empty cells.

Another way is to go to Tools>Options and choose the Chart tab.

Pick how you want data plotted - with gaps, as zero, or interpolated.






Microsoft also has this suggestion:
Gaps between the dates
"If the datasheet data for the category axis contains date number formatting, Microsoft Graph automatically uses a special type of axis in your chart called a time-scale axis.
A time-scale axis shows a blank category for dates for which you have no data. If you do not want to see these gaps — for example, if you have data for 1-Jan, 15-Jan, 3-Feb, 12-Feb, and 2-Mar, and you want to plot the days next to each other - you can change the time-scale axis to a standard category axis.
On the Chart menu, click Chart Options, click the Axes tab, and then click Category under Category (X) axis."




See all Topics

Labels:


<Doug Klippert@ 5:41 AM

Comments: Post a Comment