Drawing a straight line (Average of 25 numbers) on an Excel chart

%3CLINGO-SUB%20id%3D%22lingo-sub-1998247%22%20slang%3D%22en-US%22%3EDrawing%20a%20straight%20line%20(Average%20of%2025%20numbers)%20on%20an%20Excel%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1998247%22%20slang%3D%22en-US%22%3E%3CP%3EGreetings!%3C%2FP%3E%3CP%3EUsing%20an%20Excel%20graph%20(chart)%2C%20I%20am%20trying%20to%20show%20three%20things%3A%201)%20the%20number%20of%20voters%20in%20each%20of%2025%20wards%20in%20a%20Mid-western%20city%3B%202)%20the%20average%20of%20these%2025%20numbers%3B%20and%203)%20the%20standard%20deviation.%26nbsp%3B%20I've%20got%20a%20line%20graph%20showing%20the%20number%20of%20voters%2C%20low%20to%20high%2C%20with%20the%20ward%20identifiers%20as%20the%20X-axis%2C%20but%20I%20can't%20seem%20to%20draw%20a%20straight%20horizontal%20line%20showing%20the%20average%2C%20and%20I%20haven't%20even%20tried%20to%20show%20the%20S.D.%20yet.%26nbsp%3B%20Any%20suggestions%3F%20Thanks.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1998247%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Greetings!

Using an Excel graph (chart), I am trying to show three things: 1) the number of voters in each of 25 wards in a Mid-western city; 2) the average of these 25 numbers; and 3) the standard deviation.  I've got a line graph showing the number of voters, low to high, with the ward identifiers as the X-axis, but I can't seem to draw a straight horizontal line showing the average, and I haven't even tried to show the S.D. yet.  Any suggestions? Thanks. 

1 Reply