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

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

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

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/...gColumns.html).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______



"Gerry C" <Gerry wrote in message
...
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

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

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

"Gerry C" wrote:

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

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

Everything's easy, when you know how.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Gerry C" wrote in message
...
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

"Gerry C" wrote:

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