StuLux
Well-known Member
- Joined
- Sep 14, 2005
- Messages
- 682
- Office Version
- 365
- Platform
- Windows
I have some date data to be plotted. The data comes from various calculations and lookkups and some fo the cells will be blank on some occasions. When the cell is blank I don't want to plot the point (as Excel will, by default, presume this is a date of 00-Jan-00). Is there either a formula I can use to put something else in these cells so they are not plotted or is it something I can do within the chart formatting functions?