Horizantal and vertical representation of data using Straight table chart

[#1]

Hi,

I have databse table containing columns major,minor,assigned,resolved and closed.

I need to represent this data as attached in image.

How can i do this using straight table chart or any other chart.

Thanks in advance.

[#2]

Want to add , i am facing problem while trying to show assigned,resolved and closed data in horizantal way. Please suggest me which property i need to set for this representation.

[#3]

Hi,

how are the data stored in your "database"? Please provide your example data table(s) so I can have a look.

A pivot table should do it (here you are able to design a crosstable).

Rainer

[#4]

I have attached the excel for the sample data.

[#5]

Rainer

Please look in to exact data.

Thanks in advance.

[#6]

Hi,

I did not understand correctly what kind of table and which calculations you need using your sample data.

Please use your sample data and try to configure the table you need using excel. Hope i get it than.

Rainer

[blaise]

Your picture and your sample data doesn't match at all, but if i understand you right the attached solution should do the trick.

The key is straight table in horizontal mode with Severity as dimension and one expression per "date" field.