Simple Excel Graph/Chart ?

  • Thread starter Thread starter sean_walsh
  • Start date Start date
S

sean_walsh

Hi

I need to product a simple chart in Excel, but can't find anything
suitable.

The data I have is three simple figures: a persons results for an
exam, plus the average & median for his class.

SCORE: 52%
AVERAGE: 79%
MEDIAN: 71%

I would like to display this in a graph like so:

x o @
0% ---------------------------------------- 100%

where x = score (52%), @ = average (79%) and o = median (71%)

So, effectively, there isn't much of a Y axis. I just need the three
data points on the X axis.

Can anyone show me how to do it?

Thanks
Sean
 
Assuming you have Score in A1, Average in B1 and Median in C1, with
the values as percentages in row 2, then use these formulae:

D2: =REPT("-",A2*100)&"x"&REPT("-",99-A2*100)

E2: =MID(D2,1,B2*100-1)&"@"&RIGHT(D2,99-B2*100)

F2: =MID(E2,1,C2*100-1)&"o"&RIGHT(E2,99-C2*100)

From your example data, you will have this in F2:

----------------------------------------------------x-----------------
o-------@--------------------

(which might wrap on the newsgroups), and columns D and E could be
hidden. You might like to use a non-proportinal font like Courier, or
choose characters which have similar sizes.

Hope this helps.

Pete
 
Hi Tom & thanks for your response.

I'd prefer not to go that route, as it's a bit of a hack, and not a
proper graph. For example, if the score & the average are the same,
I'm not going to see the score on the "chart". It also isn't a
graphic, so wont scale well if fonts are changed / zoomed, etc. I
might also need to put in a range from Min to Max score, as an
additional item. So I'd prefer to do it all in a graph, if possible,
as they should be designed for such functionality.

I've actually managed to get a pretty good vertical scatter graph, so
vertical instead of horizontal - I'm not sure if that's an issue for
the client, and if i could swap the axes? Haven't found an option for
that yet.

I have played with putting in the min-max range (as a line) in the
vertical scatter chart, but it comes out skewed, i.e not 100%
vertical, not sure why. It seems to create a second X-axis point.

Is this all making sense?

Regards
Sean
 
Back
Top