I am trying to create a bar chart using data imported from Excel. This is how my excel file looks like.
I created the following function:
compareDIF[a_, b_] := (
dados = Import[a];
lateCondCC =dados[[b, 2, 4]];
lateCondEN = dados[[b, 2, 5]];
lateCondER = dados[[b, 2, 6]];
lateExtCC = dados[[b, 3, 4]];
lateExtEN = dados[[b, 3, 5]];
lateExtER = dados[[b, 3, 6]];
testCC = dados[[b, 4, 4]];
testEN = dados[[b, 4, 5]];
testER = dados[[b, 4, 6]];
BarChart[
{
lateCondCC, lateCondEN, lateCondER,
lateExtCC, lateExtEN, lateExtER,
testEN, testER,
},
ChartStyle->{{Black, White, Gray}},
BarSpacing->{0.4, 1.0},
ChartLegends->{{"Group 1", "Group 2", "Group 3"}},
PlotRange->{{0.3,9},{-0.3, 0.5}},
Frame->{False, True, False, False},
FrameLabel->{{"Time 1", "Time 2", "Time 3"}, "label"},
Ticks->{False, False},
GridLines->{{2.8, 4.8}, {0.0}},
GridLinesStyle-> Dashed,
ImageSize->550
]
);`compareDIF[a_, b_] := (
dados = Import[a];
lateCondCC =dados[[b, 2, 4]];
lateCondEN = dados[[b, 2, 5]];
lateCondER = dados[[b, 2, 6]];
lateExtCC = dados[[b, 3, 4]];
lateExtEN = dados[[b, 3, 5]];
lateExtER = dados[[b, 3, 6]];
testCC = dados[[b, 4, 4]];
testEN = dados[[b, 4, 5]];
testER = dados[[b, 4, 6]];
BarChart[
{
lateCondCC, lateCondEN, lateCondER,
lateExtCC, lateExtEN, lateExtER,
testEN, testER,
},
ChartStyle->{{Black, White, Gray}},
BarSpacing->{0.4, 1.0},
PlotRange->{{0.3,9},{-0.3, 0.5}},
Frame->{False, True, False, False},
Ticks->{False, False},
GridLines->{{2.8, 4.8}, {0.0}},
GridLinesStyle-> Dashed,
ImageSize->550
]
);
However, when I try running this function, Mathematica returns a bar chart with no data, such as this:
I would like to know why my code is not showing the data. I know this must be a very basic question, but I cannot find what I did wrong.
Thank you
{lateCondCC, lateCondEN, lateCondER...
contain? $\endgroup$b=1
? $\endgroup$