Dec 28 2022 06:14 AM
Hi
I want to develop nice and easy graph for following data for 02 years comparison.
ITEM DESCRIPTION- YEAR - 2021 | JAN-021 | FEB-021 | MAR 021 | APRIL021 | MAY 021 | JUN 021 | JUL 021 | AUG 021 | SEPT021 | OCT 021 | NOV 021 | DEC 021 | |
BLACK | 509 | 691 | 645 | 525 | 535 | 866 | 560 | 490 | 510 | 405 | 213 | 512 | |
BLUE | 90 | 104 | 189 | 90 | 125 | 132 | 135 | 105 | 150 | 155 | 155 | 192 | |
CYAN | 213 | 230 | 366 | 252 | 276 | 335 | 265 | 215 | 225 | 280 | 285 | 301 | |
MAGENTA | 152 | 155 | 218 | 120 | 128 | 175 | 145 | 135 | 181 | 148 | 180 | 176 | |
YELLOW | 314 | 321 | 320 | 387 | 295 | 400 | 315 | 260 | 320 | 247 | 370 | 401 | |
ORANGE | 152 | 171 | 167 | 195 | 157 | 210 | 170 | 150 | 168 | 148 | 190 | 203 | |
RED | 131 | 152 | 100 | 124 | 150 | 185 | 125 | 135 | 176 | 160 | 210 | 150 | |
TOTAL | 1561 | 1824 | 2005 | 1693 | 1666 | 2303 | 1715 | 1490 | 1730 | 1543 | 1603 | 1935 | |
| aprox | ||||||||||||
ITEM DESCRIPTION YEAR - 2022 | JAN-022 | FEB-022 | MAR 022 | APRIL022 | MAY 022 | JUN 022 | JUL 022 | AUG 022 | SEPT-022 | OCT-022 | NOV-022 | DEC-022 | |
BLACK | 475 | 495 | 560 | 556 | 578 | 526 | 465 | 656 | 785 | 782 | 689 | 769 | |
BLUE | 106 | 145 | 130 | 117 | 150 | 133 | 173 | 220 | 153 | 241 | 87 | 327 | |
CYAN | 296 | 270 | 271 | 330 | 302 | 279 | 350 | 279 | 333 | 370 | 199 | 335 | |
MAGENTA | 300 | 165 | 175 | 170 | 190 | 170 | 303 | 343 | 327 | 368 | 383 | 510 | |
YELLOW | 514 | 250 | 420 | 365 | 416 | 352 | 417 | 452 | 445 | 528 | 144 | 544 | |
ORANGE | 330 | 162 | 259 | 216 | 245 | 213 | 231 | 346 | 315 | 376 | 316 | 527 | |
RED | 100 | 180 | 210 | 217 | 278 | 160 | 90 | 100 | 118 | 138 | 335 | 381 | |
TOTAL | 2121 | 1667 | 2025 | 1971 | 2159 | 1833 | 2029 | 2396 | 2476 | 2803 | 2153 | 3392 |
Please help me / guide me how to develop nice and easy graph in excel / power bi.
Email : email address removed for privacy reasons
Jan 04 2023 06:30 AM
@Qaiseriqbal Are you looking for something like this?