G
Guest
I am building a benchmarking study of 176 electric utility companies, and want to create comparisons based on performance within deciles (top 10% down to bottom 10% based on specific benchmark performance). For each of the 100 utilities there is a three letter acronym, and the desired charts should compare utilities based on seven different benchmarks (one involves Inventory as a % of Revenue, and the other six involve Operations or Maintenance expenses in electric Distribution, Transmission or Generation as a percent of each of these three asset area's $ value).
The problem is, when I try to graph the bell curve type distribution of these utilities with the acronyms showing, I just get an unreadable blur of labels across the curve. What would work is if I could put each 3 letter label in its own box, and for each decile, have it stack the acronym boxes under that "column" of the bell curve alphabetically.
I am almost ready to resort to mechanically building this in an Excel worksheet itself using VLookup or some IF statements off the data column against the label column. But does anybody think there is an elegan way to create this kind of graph directly in Charts?
Thanks.
The problem is, when I try to graph the bell curve type distribution of these utilities with the acronyms showing, I just get an unreadable blur of labels across the curve. What would work is if I could put each 3 letter label in its own box, and for each decile, have it stack the acronym boxes under that "column" of the bell curve alphabetically.
I am almost ready to resort to mechanically building this in an Excel worksheet itself using VLookup or some IF statements off the data column against the label column. But does anybody think there is an elegan way to create this kind of graph directly in Charts?
Thanks.