Forum Discussion

fleuriane LP's avatar
fleuriane LP
Copper Contributor
May 16, 2018

Excel - PivotTable - How to show different labels on a chart

Hi everybody, I am a novice at Excel and I can't find a way to do something with my PivotTable, this is why I am asking for your help. I have this huge main sheet with mostly text from my Phd resea...
excel
JKPieterse's avatar
JKPieterse
Silver Contributor
May 16, 2018
Can you perhaps provide us with a small (anonymous) data sample and an example of what the end result must look like?
fleuriane LP's avatar
fleuriane LP
Copper Contributor
May 16, 2018

I tried to save on another file a sample of my work sheet. I've recreated the two pivotTables I was talking about (those that I desperately tried to do together and not in two distinct tables).

 

About the chart, I am trying to have a chart in which :

- x axis would show the number of litigation;

- y axis the years

- two different series : one for when the institution started the litigation (in french : l'institution requérante) and another when the institution had to defend itself (l'institution défenderesse).

 

Thanks for your help

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    May 16, 2018

    I used "Get & Transform" to reshape the data so I could create the pivottable needed. You can use the attached, paste your current data into the first sheet and then click refresh all. Make sure you do not change the headers of the table on the first sheet.

    • fleuriane LP's avatar
      fleuriane LP
      Copper Contributor
      May 16, 2018

      Thanks a lot. I will try that ;)