Presenting Data: Tabular and graphic display of social indicators
Gary Klass
Illinois State University

Note: The website will be discontinued shortly, to be replaced by the Just Plain Data Analysis site

Tips on Using MS Excel to Prepare Charts and Graphs .

No legend box, Text box labels lines

Right and left hand scales

How to:

Add the source citation at the bottom:

  • type the text you wish to enter in the text box just below the main menu buttons:

  • hit enter and position the text with the mouse
  • (you can do the same thing to position a single legend label next to a line -- see Children and elderly chart)

Change the order of the legend labels (e.g., so black is on top in the legend box):

  • right click on one of the lines, select format data series | series order and move the labels up or down

Add a second scale on the left:

  • format the data series for the line that will have a new scale, choose Axis | secondary axis.

Mix bars and lines

  • right-click on a line, choose chart type, select a bar chart.

Add additional drawing elements (e.g., connecting a gap in the line where there is missing data)

  • select View | Toolbars | Drawing, then select and position drawing elements

Change fonts and scale on the Y axis, fonts, alignment, and spacing on X axis:

  • right click on the axis numbers
  • choose format axis
  • select font, alignment, or scale

Excel Links:

Very Valuable Excel charting sites:

For boxplots and many other charting work arounds and applications check out Jon Peltier's "Jon's Excel and Charting Pages"

For control over data labeling (especially in scatterplots), Chart size and text size controls, and chart image copying use John Walkenbach's  J-Walk Chart tools

Other great Excel pages:

Tushar Mehta

Really stuck? Ask for advice on the newsgroup:  microsoft.public.excel.charting