Hi All
I have the below raw data and i want to create a Stacked column chart in excel 2010.
I have created the chart but only concern is the values of Data points is not aligning to Y axis bar.
Can anybody tell me how to attach the excel file which i did so that it will be helpful to you to analyse.
[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD][TABLE="width: 655"]
<colgroup><col><col><col span="2"><col><col span="3"></colgroup><tbody>[TR]
[TD]Status[/TD]
[TD]15-Jan-19[/TD]
[TD]22-Jan-19[/TD]
[TD]29-Jan-19[/TD]
[TD]5-Feb-19[/TD]
[TD]12-Feb-19[/TD]
[TD]19-Feb-19[/TD]
[TD]26-Feb-19[/TD]
[/TR]
[TR]
[TD]Fresher[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]12[/TD]
[/TR]
[TR]
[TD]Mapped[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD]PEP[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD]Not Mapped[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]12[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I have the below raw data and i want to create a Stacked column chart in excel 2010.
I have created the chart but only concern is the values of Data points is not aligning to Y axis bar.
Can anybody tell me how to attach the excel file which i did so that it will be helpful to you to analyse.
[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD][TABLE="width: 655"]
<colgroup><col><col><col span="2"><col><col span="3"></colgroup><tbody>[TR]
[TD]Status[/TD]
[TD]15-Jan-19[/TD]
[TD]22-Jan-19[/TD]
[TD]29-Jan-19[/TD]
[TD]5-Feb-19[/TD]
[TD]12-Feb-19[/TD]
[TD]19-Feb-19[/TD]
[TD]26-Feb-19[/TD]
[/TR]
[TR]
[TD]Fresher[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]12[/TD]
[/TR]
[TR]
[TD]Mapped[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD]PEP[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD]Not Mapped[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]12[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]