Dec 17 2022 06:16 AM
Hi everybody!
I'm trying to create a bar plot with the following idea: I would like it to be, for each year (X axis), have 5 bars side by side for each 'productid', the height of the bar would represent the column 'somme' like so:
Any idea of how to do that?
Year | PRODUCTID | Somme |
2011 | 352 | 1100 |
2011 | 508 | 1100 |
2011 | 507 | 1100 |
2011 | 351 | 1100 |
2011 | 530 | 550 |
2012 | 935 | 3850 |
2012 | 936 | 3850 |
2012 | 524 | 3850 |
2012 | 319 | 3850 |
2012 | 326 | 3750 |
2013 | 319 | 24200 |
2013 | 325 | 20000 |
2013 | 326 | 20000 |
2013 | 523 | 18700 |
2013 | 513 | 18150 |
2014 | 319 | 42900 |
2014 | 325 | 38750 |
2014 | 326 | 38750 |
2014 | 936 | 34100 |
2014 | 935 | 34100 |
Dec 17 2022 06:35 AM
SolutionSee the attached sample workbook for a suggestion.