Hi Gene, You can not create a truly blank cell using worksheet functions. Unfortunately, the only way to do that. is with code. However, won't truly blank cells also be considered as zero by the cdhart/graph? Regards - Dave> Date: Mon, 24 Nov 2008 12:52:54 -0800> Subject: $$Excel-Macros$$ How to generate a blank cell> From: [EMAIL PROTECTED]> To: excel-macros@googlegroups.com> > > Hi everyone,> > I am doing automatic graph with MS excel, and encounter the following> problem. I used a formula to relink the data and doing some> calculations at the same cell, so if the calculation returns an error,> it will be automatically return a "" or a " " to make the spreadsheet> clean.> > The problem is, once i tried to graph that vs another axis, those ""> or " ", which are not considered as 0 in calculation, will turn out to> be 0 on the chart/graph.> > The way i am thinking is to have some kind of formula to generate a> truly blank instead of "" or " " to make it work for both number> calculation or graph plotting.> > VBA/Macro is not preferred since someone with little excel knowledge> will use that as template, they may mess the whole thing up. However,> if VBA is required, that would be fine.> > Thank you in advance,> > Gene> > _________________________________________________________________ Your dream beach house escape for summer! Sign up for the Hotmail Road Trip today. http://www.ninemsn.com.au/hotmailroadtrip --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---
