jessicafang
Board Regular
- Joined
- Jul 8, 2015
- Messages
- 115
Hi Guys,
I am just wondering anyone could help me to build a bar chart graph.
The vertical axis is amount and horizontal axis is customers.
[TABLE="width: 500"]
<tbody>[TR]
[TD]Customer[/TD]
[TD]Week1[/TD]
[TD]Week1[/TD]
[TD]Week2[/TD]
[TD]Week2[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Act[/TD]
[TD]Fcst[/TD]
[TD]Act[/TD]
[TD]Fcst[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]10[/TD]
[TD]5[/TD]
[TD]20[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]42[/TD]
[TD]10[/TD]
[TD]20[/TD]
[TD]15[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]30[/TD]
[TD]43[/TD]
[TD]24[/TD]
[TD]18[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]49[/TD]
[TD]34[/TD]
[TD]20[/TD]
[TD]19
[/TD]
[/TR]
</tbody>[/TABLE]
Is it possible to build a bar chart with two bars per customer and one of the bar is showing week1 and the other bar is showing week2, with week 1 bar, can we have split between Act and Fcst?
Not sure how likely this can be achieved?
Many thanks for your help.
Kind regard,
Jess
I am just wondering anyone could help me to build a bar chart graph.
The vertical axis is amount and horizontal axis is customers.
[TABLE="width: 500"]
<tbody>[TR]
[TD]Customer[/TD]
[TD]Week1[/TD]
[TD]Week1[/TD]
[TD]Week2[/TD]
[TD]Week2[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Act[/TD]
[TD]Fcst[/TD]
[TD]Act[/TD]
[TD]Fcst[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]10[/TD]
[TD]5[/TD]
[TD]20[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]42[/TD]
[TD]10[/TD]
[TD]20[/TD]
[TD]15[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]30[/TD]
[TD]43[/TD]
[TD]24[/TD]
[TD]18[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]49[/TD]
[TD]34[/TD]
[TD]20[/TD]
[TD]19
[/TD]
[/TR]
</tbody>[/TABLE]
Is it possible to build a bar chart with two bars per customer and one of the bar is showing week1 and the other bar is showing week2, with week 1 bar, can we have split between Act and Fcst?
Not sure how likely this can be achieved?
Many thanks for your help.
Kind regard,
Jess