• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Fixing the color of multiple bars as per the company designation

Marc L

Excel Ninja
Hi,​
as here this is the general Excel forum section (formulas, features) what do you clearly expect for ?​
 

p45cal

Well-Known Member
In the attached has a macro blah that makes a lot of assumptions, among them:
  • There's only one series per chart
  • The companies are in cells immediately to the right of the y-values
  • It tries to work on ALL the charts of the active sheet
  • That all the companies in column D match exactly one of the cells in E1:E3
  • That the active sheet contains all the required information and chart cource data.
The button in column P runs this macro.
Hopefully this will give you a start.
 

Attachments

Last edited:
In the attached has a macro blah that makes a lot of assumptions, among them:
  • There's only one series per chart
  • The companies are in cells immediately to the right of the y-values
  • It tries to work on ALL the charts of the active sheet
  • That all the companies in column D match exactly one of the cells in E1:E3
  • That the active sheet contains all the required information and chart cource data.
The button in column P runs this macro.
Hopefully this will give you a start.
Hi p45cal,

This is really great... This is exactly I was looking for.

Regards,
Manish
 
Hi p45cal,

This is really great... This is exactly I was looking for.

Regards,
Manish
Hi p45cal,

This code was really great, however I am just looking to add further enhancement.

The color range should be selected basis the selection from Input and Assumption tab.

I have tried using conditional formating, but it dint worked.

Details are in the attached file.

Regards,
Manish
 

Attachments

Top