| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return Numeric Labels that have different Numeric Values | Excel Worksheet Functions | |||
| how can I show repeating values in a chart? | Charts and Charting in Excel | |||
| I am trying to show graphically employees working 8:30 am to 6:00 | Charts and Charting in Excel | |||
| Chart problem: values in column A don't show as labels on x-axis | Excel Discussion (Misc queries) | |||
| How can I get the zero values at the end of a chart not to show? | Charts and Charting in Excel | |||
Linear Mode
