how do i show non-numeric values graphically in a chart?

[Gerry C]

Hi - I am trying to display the following in a chart with the Euros
vertically but have NO idea how to. Any help would be VERY grtefully received
as I am at my wits end but getting nowhere.

Many thanks. Gerry

Euro 20-25 24-28 22-32 25-40 40-100
Job Scores 120-140 141-279 280-339 340-439 440-660

 

[Jon Peltier]

You need to provide Excel with some numbers to chart. Arrange the data this
way:

Job Scores 120-140 141-279 280-339 340-439 440-660
Euro Min 20 24 22 25 40
Euro Max 25 28 32 40 100

Plot Euro Min and Euro Max as line series against Job Scores. Alternatively:

Job Scores 120-140 141-279 280-339 340-439 440-660
Euro Min 20 24 22 25 40
Euro Range 5 4 10 15 60

Plot Euro Min and Euro Range as stacked columns against Job Scores, then
format the Min series to be invisible, so you have a floating column chart
(http://peltiertech.com/Excel/Charts/FloatingColumns.html).

- Jon

 

[Gerry C]

Hi,
Thankyou EVER so much - that did the trick wonderfully. I know its maybe a
simple thing but if you don't know it - you just don't know it until someone
helps you out.

Much appreciated

Gerry

 

[Jon Peltier]

Everything's easy, when you know how.

- Jon