Yeah Skip, the code is working. Thanks a lot!!
However the colors are different from the requirements, is there anything by which we get the exact colors or please let me know the way to find out the RGB format of specific color.
Thank you very much. You are a Gem buddy!!
Okay, regardless of where the coloring is accomplished, the charts end up in PP??? - Yes
For some reason, your PP PERCENTAGE charts refer to MILLIONS OF DOLLAR COLOR CODED RANGES??? Do you have an answer for that? - Will get back to you
Thanks to raise these issues, will get back to you...
Hello Skip,
You are my Man Bro!!!
Exactly the same reaction of mine also but sometimes even every time BOSS is right Dude.
I said that we can do condition formatting in Excel and then transfer the graph to PowerPoint but as per him then there would be no sense to link the graph with excel...
Yes I know that but that is how I got this project actually.
Kindly set your code as per the percentages which have been mentioned next to the color in attached excel.
Then I would have got an idea that how to do it and after that will discuss with my client how he want it, right now he wanted...
Sorry,
Please find the link for excel file.http://files.engineering.com/getfile.aspx?folder=d42a9aa5-4e02-4654-8357-7797eeaf4879&file=Conditions_for_graphs.xlsx
Hello Skip,
I used the same code as you have shared now, however code is not running due to error on this error:
Set ch = sh.Chart 'Complie Error: Method or data member not found
Also for condition of the code, I have attached the sample excel file on which Range "E36:G39" has the conditions...
Hey Skip,
I tried to run the code by changing the s variable as object but it's not working.
May I request you to share the whole code so that would be clear how you have declared the variables.
As far as color are concern for Series, actually every bar is need to be colored as per data...
Thanks Skip for prompt response.
I tried to use watch window by using the above link in your other posts but I couldn't.
Surely I am trying to use it right now.
Hello Friends,
I'm new to this forum and this is my first post.
I need help of you guys to solve a headache.
Currently I'm working on a project which require to change the Bar colors as per values of Excel linked graphs.
The problem is when the values changed in Excel sheet, values change on...
Hello Friends,
I'm new to this forum and this is my first post.
I need help of you guys to solve a headache.
Currently I'm working on a project which require to change the Bar colors as per values of Excel linked graphs.
The problem is when the values changed in Excel sheet, values change on...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.