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.

Kemahiran: Excel, VB.NET, Visual Basic, Visual Basic untuk Aplikasi

Lihat lagi: 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, silverlight specific color bar chart, refresh chart creating vba macro powerpoint, free excel vba macro code lotto numbers, bar chart silverlight source code, vba macro current chart

Tentang Majikan:
( 2 ulasan ) Wilmington, United States

ID Projek: #15853386

Dianugerahkan kepada:


Dear Client I can do this task. Roy

$100 USD dalam 2 hari
(280 Ulasan)

13 pekerja bebas membida secara purata $129 untuk pekerjaan ini


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 Lagi

$200 USD dalam 3 hari
(290 Ulasan)

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

$222 USD dalam 2 hari
(172 Ulasan)

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!

$143 USD dalam 3 hari
(121 Ulasan)
$155 USD dalam 3 hari
(65 Ulasan)

I am very able to do this and ready to start

$99 USD dalam 2 hari
(45 Ulasan)

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.

$83 USD dalam 2 hari
(23 Ulasan)

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 Lagi

$50 USD dalam 2 hari
(41 Ulasan)

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 Lagi

$155 USD dalam 2 hari
(9 Ulasan)

A proposal has not yet been provided

$166 USD dalam 7 hari
(8 Ulasan)

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 Lagi

$100 USD dalam 4 hari
(3 Ulasan)

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

$100 USD dalam sehari
(2 Ulasan)

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 Lagi

$100 USD dalam 3 hari
(0 Ulasan)