Suggestions for visualizing the table with multiple information

[anishms]

Hi All,
Appreciate any suggestions to present the attached sample data in to a dashboard or chart in power point.
Thanks in advance for your help!

 

[AlanSidman]

If the attached is what you are lookin for, as you gave us no direction on what you want the end result to look like, then Power Query is your answer

 

[anishms]

If the attached is what you are lookin for, as you gave us no direction on what you want the end result to look like, then Power Query is your answer

Thanks Alan for your time and response.
I'm not looking for a transposed table with merged cells. I saw your applied steps and realized that there is a lot to learn in power query for data transformation.
I'm basically looking for a chart including all the information that is there in the sample data. I'm not sure how better this can be converted into a chart as there are multiple information that needs to be projected such as business, case type, case by company, case against company and the year.
Thanks,

 

[AlanSidman]

Mock up a solution so that we can see exactly what you want.

 

[anishms]

Hi,
Attached WB has a chart which I would like to present with the following changes and request your help-
(1) Business 1 to 6 in horizontal axis with years in stacked column instead of each business repeating 3 times
(2) Same chart with business 1 to 6 in each year shows the stacked column for case type

 

[vletm]

anishms
Something like this ... ?

 

[p45cal]

(2) Same chart with business 1 to 6 in each year shows the stacked column for case type

Attached an adaptation of vletm's 2nd chart to try and give you what I think you want for (2) above.


You had some trailing spaces in your source data (Case Type column) which I've removed. I also arranged to hide the 0 labels.

 

[anishms]

anishms
Something like this ... ?

Thanks Vletm for your time and solution
Happy to see you after a long time.
I think I was unable to explain it clearly. I was looking for the way p45cal has provided

 

[anishms]

Attached an adaptation of vletm's 2nd chart to try and give you what I think you want for (2) above.
View attachment 77660

You had some trailing spaces in your source data (Case Type column) which I've removed. I also arranged to hide the 0 labels.

Yes, this is what I was looking for
Thanks p45cal for your time and solution

 

[vletm]

anishms
Please, next time try to show - what do You would like to get?

 

[anishms]

anishms
Please, next time try to show - what do You would like to get?

Sure vletm

 

[anishms]

Attached an adaptation of vletm's 2nd chart to try and give you what I think you want for (2) above.
View attachment 77660

You had some trailing spaces in your source data (Case Type column) which I've removed. I also arranged to hide the 0 labels.

Is it possible to bring the information of litigation by the company and against the company in this chart?
I think it will make the chart very busy difficult to read

 

[p45cal]

Is it possible to bring the information of litigation by the company and against the company in this chart?

Yes. In the attached the Case Types are the same primary colour, with the Against Company a lighter shade than the By Company.

I think it will make the chart very busy difficult to read

It does!

 

[anishms]

Yes. In the attached the Case Types are the same primary colour, with the Against Company a lighter shade than the By Company.

It does!

Thanks p45cal