I would like to make a chart using sheet 2: Raw Data 12/23.
X Axis: Month/yr
Y Axis: $ value
Please see the 3rd sheet where it says 'KPI Dashboard" find the bar chart - supplier workload. I started working on it but got stuck. I need a chart to show all bars with different colors to reflect the Purchasing Group or PG below (1AA, 1AB, 1AC, etc). For example, 1AA is red, 1AB-Blue and so on. Please let me know if you can make a chart using data in sheet 2. If you can't fix this, can you make a new one?