how to create per column in graph

[#1]

Hi all

The data will be like this

and shown in bar chart like this

and the graph that i want is like below

To make this graph I change the table structure. But it’s not suggested

Is it possible to make 2^nd graph without changing table structure?

Because I want to compare/analyse  a value for each item, because the 1^st chart cannot see the comparison between item.

Any suggestion to solve this?

Thanks

[swuehl · Accepted solution]

Try

The Crosstable Load

CROSSTABLE (ValueName, Value)

LOAD

    Name,

    "Value 1",

    "Value 2",

    "Value 3"

FROM [lib://book2/Book2.xlsx]

(ooxml, embedded labels, table is Sheet2);

Then you can easily create both charts using either

1) Name

2) ValueName

or

1) ValueName

2) Name

as your two dimensions and

=Sum(Value)

as expression.

[#3]

"crosstable" words, give me to next stage

thanks