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. Customer Week1 Week1 Week2 Week2 Act Fcst Act Fcst A 10 5 20 10 B 42 10 20 15 C 30 43 24 18 D 49 34 20 19 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

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Bar chart help please

Thread starter jessicafang
Start date Jun 6, 2018
Tags

act bar chart week1 week2

jessicafang

Board Regular

Jun 6, 2018

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