Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
chart with norm-range and value
Dear excel-professionals!
How to I get a chart that looks simlar to the following (here shown with characters) Skala1 __________--X-------__________ Skala2 __________-------X--__________ Skala3 ________X_-----------__________ etc. That means 1) the possible range of values is 1 to 100 2) each line has a "norm-range", fx 40 to 60, that should have a grey background (here shown as hyphen "-") 3) the range outside the norm range (ie 1 to 40 and 60 to 100) can stay white/blank (here shown as underscore "_") 4) each line has a "value" to be shown as black dot or similar (here shown as "X") 1 to 100 are percents 40 to 60 is a so called norm-range, but can also have different values in each line "Value" is a test-result to be shown in relation to norm-range (laying within or outside norm range). Thank you for any hints regards - hermann - |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
chart with norm-range and value
Hi,
It sounds like you could use a Bar chart with 3 series, 0-40, 40-60, 60-100. -- Cheers, Shane Devenshire "Hermann Schaffer" wrote: Dear excel-professionals! How to I get a chart that looks simlar to the following (here shown with characters) Skala1 __________--X-------__________ Skala2 __________-------X--__________ Skala3 ________X_-----------__________ etc. That means 1) the possible range of values is 1 to 100 2) each line has a "norm-range", fx 40 to 60, that should have a grey background (here shown as hyphen "-") 3) the range outside the norm range (ie 1 to 40 and 60 to 100) can stay white/blank (here shown as underscore "_") 4) each line has a "value" to be shown as black dot or similar (here shown as "X") 1 to 100 are percents 40 to 60 is a so called norm-range, but can also have different values in each line "Value" is a test-result to be shown in relation to norm-range (laying within or outside norm range). Thank you for any hints regards - hermann - |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
chart with norm-range and value
Well, yes, I tried a stapled bar, had another columne for "value" and
changed that to an XY-Matrix chart. But a cannot fit the dots over the respective bars. Anyway, this kind of chart describes values in percentage withing a Gauss distribution (not sure I got the translation right) which is standard fx in a lot of (psychological) tests. I thought there must be a standard chart and that I just cannot find it. But thanks anyway. Regards - hermann - "ShaneDevenshire" schrieb im Newsbeitrag ... Hi, It sounds like you could use a Bar chart with 3 series, 0-40, 40-60, 60-100. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I shade area under a norm dist graph? | Charts and Charting in Excel | |||
Excel -My paste menu is not the norm. The menu is different. | Setting up and Configuration of Excel | |||
x y scatter chart series ranges reset to x(range) = y(range) | Charts and Charting in Excel | |||
Can I use named range in data range box when creating pie chart? | Charts and Charting in Excel | |||
Icons at the top are suddenly large. How do I return them to norm | Excel Discussion (Misc queries) |