ashley1984
New Member
- Joined
- Mar 31, 2018
- Messages
- 32
- Office Version
- 365
- Platform
- Windows
Hi,
I am struggling to display data in a visual way. I am trying to show a customers market growth across several categories and then my companies growth in those categories relative to the market growth. As an example:
In Category 1, Customer A had growth of 2% in the market but our business performance was +1.55% so we grew behind the market and business A. I want to show this in a visual way.
I hope the table below will help you understand the data and what I am trying to show
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD][TABLE="width: 79"]
<tbody>[TR]
[TD="class: xl65, width: 79"]Customer A[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 78"]
<tbody>[TR]
[TD="class: xl65, width: 78"]Customer B[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 78"]
<tbody>[TR]
[TD="class: xl65, width: 78"]Customer C[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 256"]
<tbody>[TR]
[TD="class: xl65, width: 256"]Business Performance with Customer A[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 267"]
<tbody>[TR]
[TD="class: xl65, width: 267"]Business Performance B with Customer B[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 267"]
<tbody>[TR]
[TD="class: xl65, width: 267"]Business Performance C with Customer C[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 72"]
<tbody>[TR]
[TD="class: xl65, width: 72"]Category 1[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 79"]
<tbody>[TR]
[TD="class: xl65, width: 79, align: right"]2.00%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 78"]
<tbody>[TR]
[TD="class: xl65, width: 78, align: right"]1.50%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 78"]
<tbody>[TR]
[TD="class: xl65, width: 78, align: right"]2.50%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 256"]
<tbody>[TR]
[TD="class: xl65, width: 256, align: right"]1.55%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 267"]
<tbody>[TR]
[TD="class: xl65, width: 267, align: right"]1.05%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 267"]
<tbody>[TR]
[TD="class: xl65, width: 267, align: right"]2.05%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 72"]
<tbody>[TR]
[TD="class: xl65, width: 72"]Category 2[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 79"]
<tbody>[TR]
[TD="class: xl65, width: 79, align: right"]2.80%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 78"]
<tbody>[TR]
[TD="class: xl65, width: 78, align: right"]3.20%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 78"]
<tbody>[TR]
[TD="class: xl65, width: 78, align: right"]1.80%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 256"]
<tbody>[TR]
[TD="class: xl65, width: 256, align: right"]3.90%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 267"]
<tbody>[TR]
[TD="class: xl65, width: 267, align: right"]4.30%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 267"]
<tbody>[TR]
[TD="class: xl65, width: 267, align: right"]2.90%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 72"]
<tbody>[TR]
[TD="class: xl65, width: 72"]Category 3[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 79"]
<tbody>[TR]
[TD="class: xl65, width: 79, align: right"]3.40%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 78"]
<tbody>[TR]
[TD="class: xl65, width: 78, align: right"]3.20%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 78"]
<tbody>[TR]
[TD="class: xl65, width: 78, align: right"]3.12%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 256"]
<tbody>[TR]
[TD="class: xl65, width: 256, align: right"]4.20%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 267"]
<tbody>[TR]
[TD="class: xl65, width: 267, align: right"]4.00%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 267"]
<tbody>[TR]
[TD="class: xl65, width: 267, align: right"]1.62%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 72"]
<tbody>[TR]
[TD="class: xl65, width: 72"]Category 4[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 79"]
<tbody>[TR]
[TD="class: xl65, width: 79, align: right"]-4.20%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 78"]
<tbody>[TR]
[TD="class: xl65, width: 78, align: right"]-2.80%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 78"]
<tbody>[TR]
[TD="class: xl65, width: 78, align: right"]0.15%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 256"]
<tbody>[TR]
[TD="class: xl65, width: 256, align: right"]-3.40%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 267"]
<tbody>[TR]
[TD="class: xl65, width: 267, align: right"]-2.00%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 267"]
<tbody>[TR]
[TD="class: xl65, width: 267, align: right"]-1.35%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 72"]
<tbody>[TR]
[TD="class: xl65, width: 72"]Category 5[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 79"]
<tbody>[TR]
[TD="class: xl65, width: 79, align: right"]-1.80%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 78"]
<tbody>[TR]
[TD="class: xl65, width: 78, align: right"]-0.50%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 78"]
<tbody>[TR]
[TD="class: xl65, width: 78, align: right"]-2.65%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 256"]
<tbody>[TR]
[TD="class: xl65, width: 256, align: right"]-1.00%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 267"]
<tbody>[TR]
[TD="class: xl65, width: 267, align: right"]-2.00%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 267"]
<tbody>[TR]
[TD="class: xl65, width: 267, align: right"]-3.85%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
I am struggling to display data in a visual way. I am trying to show a customers market growth across several categories and then my companies growth in those categories relative to the market growth. As an example:
In Category 1, Customer A had growth of 2% in the market but our business performance was +1.55% so we grew behind the market and business A. I want to show this in a visual way.
I hope the table below will help you understand the data and what I am trying to show
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD][TABLE="width: 79"]
<tbody>[TR]
[TD="class: xl65, width: 79"]Customer A[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 78"]
<tbody>[TR]
[TD="class: xl65, width: 78"]Customer B[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 78"]
<tbody>[TR]
[TD="class: xl65, width: 78"]Customer C[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 256"]
<tbody>[TR]
[TD="class: xl65, width: 256"]Business Performance with Customer A[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 267"]
<tbody>[TR]
[TD="class: xl65, width: 267"]Business Performance B with Customer B[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 267"]
<tbody>[TR]
[TD="class: xl65, width: 267"]Business Performance C with Customer C[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 72"]
<tbody>[TR]
[TD="class: xl65, width: 72"]Category 1[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 79"]
<tbody>[TR]
[TD="class: xl65, width: 79, align: right"]2.00%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 78"]
<tbody>[TR]
[TD="class: xl65, width: 78, align: right"]1.50%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 78"]
<tbody>[TR]
[TD="class: xl65, width: 78, align: right"]2.50%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 256"]
<tbody>[TR]
[TD="class: xl65, width: 256, align: right"]1.55%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 267"]
<tbody>[TR]
[TD="class: xl65, width: 267, align: right"]1.05%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 267"]
<tbody>[TR]
[TD="class: xl65, width: 267, align: right"]2.05%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 72"]
<tbody>[TR]
[TD="class: xl65, width: 72"]Category 2[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 79"]
<tbody>[TR]
[TD="class: xl65, width: 79, align: right"]2.80%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 78"]
<tbody>[TR]
[TD="class: xl65, width: 78, align: right"]3.20%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 78"]
<tbody>[TR]
[TD="class: xl65, width: 78, align: right"]1.80%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 256"]
<tbody>[TR]
[TD="class: xl65, width: 256, align: right"]3.90%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 267"]
<tbody>[TR]
[TD="class: xl65, width: 267, align: right"]4.30%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 267"]
<tbody>[TR]
[TD="class: xl65, width: 267, align: right"]2.90%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 72"]
<tbody>[TR]
[TD="class: xl65, width: 72"]Category 3[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 79"]
<tbody>[TR]
[TD="class: xl65, width: 79, align: right"]3.40%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 78"]
<tbody>[TR]
[TD="class: xl65, width: 78, align: right"]3.20%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 78"]
<tbody>[TR]
[TD="class: xl65, width: 78, align: right"]3.12%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 256"]
<tbody>[TR]
[TD="class: xl65, width: 256, align: right"]4.20%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 267"]
<tbody>[TR]
[TD="class: xl65, width: 267, align: right"]4.00%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 267"]
<tbody>[TR]
[TD="class: xl65, width: 267, align: right"]1.62%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 72"]
<tbody>[TR]
[TD="class: xl65, width: 72"]Category 4[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 79"]
<tbody>[TR]
[TD="class: xl65, width: 79, align: right"]-4.20%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 78"]
<tbody>[TR]
[TD="class: xl65, width: 78, align: right"]-2.80%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 78"]
<tbody>[TR]
[TD="class: xl65, width: 78, align: right"]0.15%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 256"]
<tbody>[TR]
[TD="class: xl65, width: 256, align: right"]-3.40%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 267"]
<tbody>[TR]
[TD="class: xl65, width: 267, align: right"]-2.00%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 267"]
<tbody>[TR]
[TD="class: xl65, width: 267, align: right"]-1.35%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 72"]
<tbody>[TR]
[TD="class: xl65, width: 72"]Category 5[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 79"]
<tbody>[TR]
[TD="class: xl65, width: 79, align: right"]-1.80%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 78"]
<tbody>[TR]
[TD="class: xl65, width: 78, align: right"]-0.50%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 78"]
<tbody>[TR]
[TD="class: xl65, width: 78, align: right"]-2.65%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 256"]
<tbody>[TR]
[TD="class: xl65, width: 256, align: right"]-1.00%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 267"]
<tbody>[TR]
[TD="class: xl65, width: 267, align: right"]-2.00%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 267"]
<tbody>[TR]
[TD="class: xl65, width: 267, align: right"]-3.85%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]