I'm trying to build a stacked column chart in which each group of data will be sorted by descending share (by channel). My data is set-up in the following way:
<table x:str="" style="border-collapse: collapse; width: 224pt;" width="300" border="0" cellpadding="0" cellspacing="0"><col style="width: 56pt;" span="4" width="75"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt; width: 56pt;" width="75" height="17">Channel</td> <td class="xl24" style="border-left: medium none; width: 56pt;" width="75">Group A</td> <td class="xl24" style="border-left: medium none; width: 56pt;" width="75">Group B</td> <td class="xl24" style="border-left: medium none; width: 56pt;" width="75">Group C</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="border-top: medium none; height: 12.75pt;" x:num="" align="right" height="17">1</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">0.5</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">0.8</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="border-top: medium none; height: 12.75pt;" x:num="" align="right" height="17">2</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">0.4</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">0.3</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">0.2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="border-top: medium none; height: 12.75pt;" x:num="" align="right" height="17">3</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">0.7</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="border-top: medium none; height: 12.75pt;" x:num="" align="right" height="17">4</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">0.3</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">0.1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="border-top: medium none; height: 12.75pt;" x:num="" align="right" height="17">5</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">0.2</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">0.8</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="border-top: medium none; height: 12.75pt;" x:num="" align="right" height="17">6</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">1</td> </tr> </tbody></table>
The way I have it set-up now, I can only have the stacks sorted by one of the groups or by channel (here sorted by descending Group A). Is there a relatively simple way to sort each of the columns (Groups A-C) descending in the chart, yet retain the appropriate channel label?
For example, I want my chart to be set-up like this:
<table x:str="" style="border-collapse: collapse; width: 336pt;" width="450" border="0" cellpadding="0" cellspacing="0"><col style="width: 56pt;" span="6" width="75"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt; width: 56pt;" width="75" height="17">Channel</td> <td class="xl24" style="border-left: medium none; width: 56pt;" width="75">Group A</td> <td class="xl24" style="border-left: medium none; width: 56pt;" width="75">Channel</td> <td class="xl24" style="border-left: medium none; width: 56pt;" width="75">Group B</td> <td class="xl24" style="border-left: medium none; width: 56pt;" width="75">Channel</td> <td class="xl24" style="border-left: medium none; width: 56pt;" width="75">Group C</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="border-top: medium none; height: 12.75pt;" x:num="" align="right" height="17">1</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">0.5</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">5</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">0.8</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">6</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="border-top: medium none; height: 12.75pt;" x:num="" align="right" height="17">2</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">0.4</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">3</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">0.7</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">1</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">0.8</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="border-top: medium none; height: 12.75pt;" x:num="" align="right" height="17">4</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">0.3</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">2</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">0.3</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">2</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">0.2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="border-top: medium none; height: 12.75pt;" x:num="" align="right" height="17">5</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">0.2</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">1</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">4</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">0.1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="border-top: medium none; height: 12.75pt;" x:num="" align="right" height="17">3</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">4</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">3</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="border-top: medium none; height: 12.75pt;" x:num="" align="right" height="17">6</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">6</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">5</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> </tr> </tbody></table>
I cannot figure out how to get data set-up like this to chart the way I would like it to, though.
Thank you for your help,
Sarah
<table x:str="" style="border-collapse: collapse; width: 224pt;" width="300" border="0" cellpadding="0" cellspacing="0"><col style="width: 56pt;" span="4" width="75"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt; width: 56pt;" width="75" height="17">Channel</td> <td class="xl24" style="border-left: medium none; width: 56pt;" width="75">Group A</td> <td class="xl24" style="border-left: medium none; width: 56pt;" width="75">Group B</td> <td class="xl24" style="border-left: medium none; width: 56pt;" width="75">Group C</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="border-top: medium none; height: 12.75pt;" x:num="" align="right" height="17">1</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">0.5</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">0.8</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="border-top: medium none; height: 12.75pt;" x:num="" align="right" height="17">2</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">0.4</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">0.3</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">0.2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="border-top: medium none; height: 12.75pt;" x:num="" align="right" height="17">3</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">0.7</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="border-top: medium none; height: 12.75pt;" x:num="" align="right" height="17">4</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">0.3</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">0.1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="border-top: medium none; height: 12.75pt;" x:num="" align="right" height="17">5</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">0.2</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">0.8</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="border-top: medium none; height: 12.75pt;" x:num="" align="right" height="17">6</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">1</td> </tr> </tbody></table>
The way I have it set-up now, I can only have the stacks sorted by one of the groups or by channel (here sorted by descending Group A). Is there a relatively simple way to sort each of the columns (Groups A-C) descending in the chart, yet retain the appropriate channel label?
For example, I want my chart to be set-up like this:
<table x:str="" style="border-collapse: collapse; width: 336pt;" width="450" border="0" cellpadding="0" cellspacing="0"><col style="width: 56pt;" span="6" width="75"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt; width: 56pt;" width="75" height="17">Channel</td> <td class="xl24" style="border-left: medium none; width: 56pt;" width="75">Group A</td> <td class="xl24" style="border-left: medium none; width: 56pt;" width="75">Channel</td> <td class="xl24" style="border-left: medium none; width: 56pt;" width="75">Group B</td> <td class="xl24" style="border-left: medium none; width: 56pt;" width="75">Channel</td> <td class="xl24" style="border-left: medium none; width: 56pt;" width="75">Group C</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="border-top: medium none; height: 12.75pt;" x:num="" align="right" height="17">1</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">0.5</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">5</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">0.8</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">6</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="border-top: medium none; height: 12.75pt;" x:num="" align="right" height="17">2</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">0.4</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">3</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">0.7</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">1</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">0.8</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="border-top: medium none; height: 12.75pt;" x:num="" align="right" height="17">4</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">0.3</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">2</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">0.3</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">2</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">0.2</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="border-top: medium none; height: 12.75pt;" x:num="" align="right" height="17">5</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">0.2</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">1</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">4</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">0.1</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="border-top: medium none; height: 12.75pt;" x:num="" align="right" height="17">3</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">4</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">3</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="border-top: medium none; height: 12.75pt;" x:num="" align="right" height="17">6</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">6</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> <td class="xl24" style="border-top: medium none; border-left: medium none;" x:num="" align="right">5</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">
</td> </tr> </tbody></table>
I cannot figure out how to get data set-up like this to chart the way I would like it to, though.
Thank you for your help,
Sarah
