• 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

Hi,

I want to fix the color of bars for the charts.

I have more than 100 charts in my workbook. As a sample I have only added three charts in the attached file.

Details are in the attached spreadsheet

Regards,
Manish
 

Attachments

  • Fixing the Color of Bars as per their Designation.xlsm
    31.3 KB · Views: 2
Hi,​
as here this is the general Excel forum section (formulas, features) what do you clearly expect for ?​
 
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

  • Chandoo46295Fixing the Color of Bars as per their Designation.xlsm
    41.2 KB · Views: 7
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

  • Chandoo46295Fixing the Color of Bars as per their Designation.xlsm
    42.3 KB · Views: 8
Back
Top