Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. brajcool

    on PowerPoint Presentation, Change the each Bar color of Excel Linked Graphs as per their value

    Thank you very much Skip. Your code is really helpful and I am very thankful to your help. Thanks a lot buddy!!
  2. brajcool

    on PowerPoint Presentation, Change the each Bar color of Excel Linked Graphs as per their value

    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!!
  3. brajcool

    on PowerPoint Presentation, Change the each Bar color of Excel Linked Graphs as per their value

    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...
  4. brajcool

    on PowerPoint Presentation, Change the each Bar color of Excel Linked Graphs as per their value

    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...
  5. brajcool

    on PowerPoint Presentation, Change the each Bar color of Excel Linked Graphs as per their value

    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...
  6. brajcool

    on PowerPoint Presentation, Change the each Bar color of Excel Linked Graphs as per their value

    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
  7. brajcool

    on PowerPoint Presentation, Change the each Bar color of Excel Linked Graphs as per their value

    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...
  8. brajcool

    on PowerPoint Presentation, Change the each Bar color of Excel Linked Graphs as per their value

    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...
  9. brajcool

    on PowerPoint Presentation, Change the each Bar color of Excel Linked Graphs as per their value

    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.
  10. brajcool

    on PowerPoint Presentation, Change the each Bar color of Excel Linked Graphs as per their value

    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...
  11. brajcool

    on PowerPoint Presentation, Change the each Bar color of Excel Linked Graphs as per their value

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

Part and Inventory Search

Back
Top