P
(PeteCresswell)
I tried this on microsoft.public.excel, but no nibbles.
And, come to think of it, maybe this is a more appropriate forum
bco the request for Object and/or Property names....
-------------------------------------------------------------
I've got some data points that represent "Rating" quality
securities batched by number of days to maturity.
e.g.
For 01-07 days, the rating quality might be .99
For 08-30 days, the rating quality might be .83.... and so forth.
What I want is a bar chart with a bar for each group of days
where the bar represents the relative rating quality of that
group. Bigger bars = Higher quality.
Rating weights, however, are on the order of .25 = good and 2 =
really bad.
So the first thing I do in invert those numbers by subtracting
them from 3.... so good = 2.75 and really bad = 1.
Going that route, I can get the bars, but I am at a loss for how
to assign rating names like "AAA" (numeric = .25, inverted to
2.75) and "A-" (numeric = 1.75, inverted to 1.25)
Screen snap of where I am so far: http://tinyurl.com/46rdke8
Instead of "1", "2", and so-forth along the X axis, I want "1-7
Days", "8-30 Days", and so-forth.
Instead of "1.75", "2", and so-forth along the Y axis, I want
"A-", "AA-", and so-forth.
In the end, I'll need to do this via VBA in MS Access working on
an Excel.Application object.... but I'm so clueless that I figure
the first step is to make it work in plain old Excel (2003).
Can anybody aim me at the relevant Property names or whatever to
customize those X/Y axis labels?
And, come to think of it, maybe this is a more appropriate forum
bco the request for Object and/or Property names....
-------------------------------------------------------------
I've got some data points that represent "Rating" quality
securities batched by number of days to maturity.
e.g.
For 01-07 days, the rating quality might be .99
For 08-30 days, the rating quality might be .83.... and so forth.
What I want is a bar chart with a bar for each group of days
where the bar represents the relative rating quality of that
group. Bigger bars = Higher quality.
Rating weights, however, are on the order of .25 = good and 2 =
really bad.
So the first thing I do in invert those numbers by subtracting
them from 3.... so good = 2.75 and really bad = 1.
Going that route, I can get the bars, but I am at a loss for how
to assign rating names like "AAA" (numeric = .25, inverted to
2.75) and "A-" (numeric = 1.75, inverted to 1.25)
Screen snap of where I am so far: http://tinyurl.com/46rdke8
Instead of "1", "2", and so-forth along the X axis, I want "1-7
Days", "8-30 Days", and so-forth.
Instead of "1.75", "2", and so-forth along the Y axis, I want
"A-", "AA-", and so-forth.
In the end, I'll need to do this via VBA in MS Access working on
an Excel.Application object.... but I'm so clueless that I figure
the first step is to make it work in plain old Excel (2003).
Can anybody aim me at the relevant Property names or whatever to
customize those X/Y axis labels?