Excel Technical graph development , 07 variable for 02 years comparision

Copper Contributor

Hi

 

I want to develop nice and easy graph for following data for 02 years comparison.

ITEM DESCRIPTION- YEAR - 2021 JAN-021FEB-021MAR 021APRIL021MAY 021JUN 021JUL 021AUG 021SEPT021OCT 021NOV 021DEC 021
BLACK   509691645525535866560490510405213512
BLUE   9010418990125132135105150155155192
CYAN  213230366252276335265215225280285301
MAGENTA   152155218120128175145135181148180176
YELLOW   314321320387295400315260320247370401
ORANGE  152171167195157210170150168148190203
RED   131152100124150185125135176160210150
TOTAL 156118242005169316662303171514901730154316031935
              

 

          aprox

ITEM DESCRIPTION

YEAR - 2022

 JAN-022FEB-022MAR 022APRIL022MAY 022JUN 022JUL 022AUG 022SEPT-022OCT-022NOV-022DEC-022
BLACK   475495560556578526465656785782689769
BLUE   10614513011715013317322015324187327
CYAN  296270271330302279350279333370199335
MAGENTA   300165175170190170303343327368383510
YELLOW   514250420365416352417452445528144544
ORANGE  330162259216245213231346315376316527
RED   10018021021727816090100118138335381
TOTAL 212116672025197121591833202923962476280321533392

 

Please help me / guide me how to develop nice and easy graph in excel / power bi.

Email : email address removed for privacy reasons

 

1 Reply

@Qaiseriqbal Are you looking for something like this?