 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Charting / July 2007How Prevent Zero Data From Later This Week From Getting Graphed?
- My X-axis data is a weekly date. - My Y-axis data is a number entered weekly. - One day after the weekly date when the data number is entered, the chart line drops off to zero, presumably because there is no data number entered and one won't be until the next weekly data entry date. How can I prevent this line from dropping off to zero? xl2007: Right click on chart. Then click Select Data, click on Hidden and empty cells (bottom left of dialog box) and and check box as to how to handle empty cells. xl2002: Click on chart to select it. Select Tools->Options->chart tab and set the Plot empty cells. (I think xl 2003 is same or similar) Not sure of other versions. If one of the above is not your version then post your version of xl. Regards, OssieMac Regards, OddieMac > - My X-axis data is a weekly date. > - My Y-axis data is a number entered weekly. [quoted text clipped - 3 lines] > number entered and one won't be until the next weekly data entry > date. How can I prevent this line from dropping off to zero? If the "blank" cell contains a formula that returns "", then it is not blank, and any Plot Blank Cells As setting will be ignored. You need to change the formula so it returns NA(). NA() produces the #N/A error in the cell, but a line or XY chart will not plot the associated point. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ > xl2007: Right click on chart. Then click Select Data, click on Hidden and > empty cells (bottom left of dialog box) and and check box as to how to [quoted text clipped - 22 lines] >> number entered and one won't be until the next weekly data entry >> date. How can I prevent this line from dropping off to zero? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.