Completed

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.

Skills: Excel, VB.NET, Visual Basic, Visual Basic for Apps

See more: 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, next empty cell vba macro paste, excel vba macro paste adjacent column, vba macro excel unicode

About the Employer:
( 1 review ) Wilmington, United States

Project ID: #15853386

Awarded to:

TonmoyRoy111

Dear Client I can do this task. Roy

$100 USD in 2 days
(221 Reviews)
6.3

15 freelancers are bidding on average $130 for this job

schoudhary1553

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 More

$200 USD in 3 days
(207 Reviews)
7.1
avinav606lx

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 in 2 days
(148 Reviews)
6.4
katilinas

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 in 3 days
(101 Reviews)
6.2
asadkhan3533

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 More

$133 USD in 3 days
(36 Reviews)
5.0
sonarkaushik

I am very able to do this and ready to start

$99 USD in 2 days
(42 Reviews)
5.6
nurnga1218

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 More

$50 USD in 2 days
(33 Reviews)
4.4
$155 USD in 3 days
(12 Reviews)
4.5
chintuag

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 More

$155 USD in 2 days
(7 Reviews)
3.7
vmadhavan15

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 in 2 days
(6 Reviews)
3.3
mpunn2007

A proposal has not yet been provided

$166 USD in 7 days
(8 Reviews)
3.1
itwonder1

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 More

$100 USD in 3 days
(0 Reviews)
0.0
dinhfreedom

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

$100 USD in 1 day
(0 Reviews)
0.0
reedsystems

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 More

$100 USD in 4 days
(1 Review)
0.0
bturner7

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

$150 USD in 3 days
(0 Reviews)
0.0