Simple Excel Graph/Chart ?

[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

 

[Pete_UK]

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

 

[seanmatthewwalsh]

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