Edit existing VBA macro to color code bar chart


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.

Beceriler: Excel, VB.NET, Visual Basic, Uygulamalar için Visual Basic

Daha fazlasını gör: excel vba chart line color index, vba chart background color, excel bar graph color conditional formatting, vba change chart color, vba powerpoint chart series color, excel vba chart series color, automatically set chart series colors to match source cell colors, excel vba bar chart fill color, vba macro org chart, macro excel 2010 pie chart color, vba code speedometer chart, convert xml csv vba macro code, upload image color code excel vba, stacked bar chart using telerik source code, vba macro code accept data entry

İşveren Hakkında:
( 1 değerlendirme ) Wilmington, United States

Proje NO: #15853386



Dear Client I can do this task. Roy

%selectedBids___i_period_sub_7% gün içinde 100%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(221 Değerlendirme)

Bu iş için 15 freelancer ortalamada $130 teklif veriyor


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

in %bids___i_period_sub_35% gün içinde200%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(207 Değerlendirme)

Hi there, I am expert in Excel VBA with over 5+ years of experience. Ping me to discuss more about the project. Thanks Aman

in %bids___i_period_sub_35% gün içinde222%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(148 Değerlendirme)

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!

in %bids___i_period_sub_35% gün içinde143%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(101 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde133%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(36 Değerlendirme)

I am very able to do this and ready to start

in %bids___i_period_sub_35% gün içinde99%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(42 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde50%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(33 Değerlendirme)
in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(12 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde155%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(7 Değerlendirme)

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.

in %bids___i_period_sub_35% gün içinde83%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(6 Değerlendirme)

A proposal has not yet been provided

in %bids___i_period_sub_35% gün içinde166%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(8 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

--Very Nice Job. Professional Excel, VB.NET, Visual Basic, Visual Basic for Apps expert. Best result in time----- Relevant Skills and Experience [login to view URL] I am very interesting for your project because I have rich Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)

--------------------------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

in %bids___i_period_sub_35% gün içinde150%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)