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.
15 freelancers are bidding on average $130 for this job
Greetings, I can start your job immediately. Read your project details and can complete your job as per your expections . Relevant Skills and Experience I have more than 7 years of experience with excellent knowledge Daha Fazla
Hi there, I am expert in Excel VBA with over 5+ years of experience. Ping me to discuss more about the project. Thanks Aman
Hello. 30 % of employers hiring me once hired me again. I have 5 years experience in VBA. I CAN do this job, and do it well!
Please review my profile as i have relevant skills and experience required for this project Relevant Skills and Experience Excel, VB.NET, Visual Basic, Visual Basic for Apps Proposed Milestones $133 USD - Excel, VB.N Daha Fazla
Hi, I've downloaded and review your macro code, I think I understand how to change it as you want. I'll try to do soon after you reply me. Relevant Skills and Experience I am an excel and VBA expert anyway. Proposed Daha Fazla
Dear Hiring Manager, I have already worked on your file and have got the solution to your first requirement i.e. color coding of the bars based on the font color of the data. Regarding your second requirement, the b Daha Fazla
I am not random bidder. I hope I can help you on this one. Please ping me if you are interested with my proposal and thank you.
Hi, I can do this work. Individual and hard working person done your work accurately. Waiting your response. Relevant Skills and Experience Excel, VB.NET, Visual Basic, Visual Basic for Apps Proposed Milestones $1 Daha Fazla
--Very Nice Job. Professional Excel, VB.NET, Visual Basic, Visual Basic for Apps expert. Best result in time----- Relevant Skills and Experience [url removed, login to view] I am very interesting for your project because I have rich Daha Fazla
Hi, how are you today? I read the description of your request and I took a look at the attached excel file. I understand the two requirements. Relevant Skills and Experience I can provide you with the modification wi Daha Fazla
--------------------------Professional Excel VBA Expert! Best Result in Time!---------------------- Dear sir. I read your project description very carefully. I've really rich experience in excel VBA developing, so Daha Fazla