Edit existing VBA macro to color code bar chart

Hello, The code I need edited in the attached workbook is an "autocreatecharts" macro that creates two charts (one doughnut chart, one bar chart) for each user's row of data from multiple sheets and puts them on "sheet2". What I need is: 1) the macro to now is color code the horizontal axis bars in the bar chart to match the font color from the corresponding data on "sheet4". I'd like this to happen dynamically so that I can change the color of the font in those columns and have it reflected in the color of the horizontal bar. It also needs to apply to all populated rows/columns of data instead of a fixed number of row/columns. 2) I'd like the bar chart for each user to only reflect data other than "0/null". So, if any cell for a user in the bar chart has a value of "0" or null or is empty, I'd like for it not to even show. There should be no bar values of 0 or null. The only edits made should affect the bar charts created. An example of the desired result is on the "chart example" sheet. If this is impossible and needs to have the colors preset in the code or, if the horizontal bars cannot be edited to omit "0" value data, please explain and offer an alternative solution. Thanks and I look forward to reviewing your quotes.