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