Hi Daniel, The attachment is missing,
Regards, Kunal On Jul 19, 4:47 pm, "Daniel" <dcolarde...@free.fr> wrote: > Hi. > Look at the attached file. > I put a button for each condition for testing purposes. > I found nothing to matches for condition3 and 4. Can you test further ? > When it will be OK, I put the code in a Worksheet_Calculate event so that it > will be updated each time the values changes. > Daniel > > > > > -----Original Message----- > > From: excel-macros@googlegroups.com [mailto:excel- > > mac...@googlegroups.com] On Behalf Of kunal > > Sent: dimanche 19 juillet 2009 06:50 > > To: MS EXCEL AND VBA MACROS > > Subject: $$Excel-Macros$$ Re: Help regarding graph in excel > > > Hi Daniel, > > > Thanks for resolving this. About the query. If the data point satisfies > any of > > the condition then it will fine.and they can all be in the same color > > > Thanks again for the help . > > > Regards, > > > Kunal > > > On Jul 18, 8:57 pm, "Daniel" <dcolarde...@free.fr> wrote: > > > Hi Kunal, > > > > Try replacing 0 value with "#NA!" values (attached file). My concern > > > was that, applying the same pattern to condition 2, most of the data > > > points are altered. Moreover, if a point abides to both conditions 1 > > > and 2, how should it show ? > > > > Regards. > > > > Daniel > > > > From: excel-macros@googlegroups.com > > > [mailto:excel-mac...@googlegroups.com] > > > On Behalf Of kunal > > > Sent: samedi 18 juillet 2009 16:48 > > > To: excel-macros@googlegroups.com > > > Subject: $$Excel-Macros$$ Re: Help regarding graph in excel > > > > Hi Daniel, > > > > Thanks for the reply, > > > > I have attached the file in which i tried to do something but zeros > > > are getting populated in to the graph which should not be the case. > > > > If your macro can populate only the values (and not zeros) that are > > > getting populated in the column 'L' in the attached file, then it > > > would solve the problem. > > > > Regards, > > > > Kunal > > > > Template (Kunal).xls > > > 141KViewDownload --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
