Help to do a StakedBar chart

[#1]

Hi Community

I have a problem with a Stacked bar chart

Tab "Graphic2"

Using a table Grafico2 (a table with 3 field) make the Stacked bar chart is very easy

(Image A)

But , and here is my problem

Tab "Graphic1"

Using a table Grafico1 (a table with 4 field) make the Stacked bar is very hard for me

(Image B)

I need to get a Staked Bar chart like the Image A

I add my qvw file

I will apreciate any suggestions

Thanks

[ramoncova06 · Accepted solution]

tienes un problema con el formato de tus datos

usa =text(Graf1_Ano) y =text(Graf1_Estado) como dimensiones y con eso ya te sale la grafica que quieres

[#3]

Hi Ramon

I tried your suggestion, and It works perfectly.

A lot of thanks