If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
do not chart cells linked from worksheets that are blank
I do not want cells to show up on the chart that are blank. The chart is
reading off boxes that the user needs to see, these boxes are linked to many different spreadsheets. that will be updated each period but the chart reads future information as zero until data is entered, just because they are linked. In he actual linked sheet I have tried no data, I have tried N/A a dash - but nothing seems to work. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
checking that cells have a value before the workbook will close | kcdonaldson | Worksheet Functions | 8 | December 5th, 2005 04:57 PM |
Problem with sorting a column of numbers (descending) - top two cells are blank. | LDH | Worksheet Functions | 1 | August 13th, 2004 07:08 PM |
averaging linked cells | Peo Sjoblom | Worksheet Functions | 0 | June 1st, 2004 07:35 PM |
Formulas employing cells linked to a combo box drop list | Frank Kabel | Worksheet Functions | 3 | May 27th, 2004 04:44 PM |
Multiple Conditional Formats for A Chart (Please Help)? | Jon Peltier | Charts and Charting | 0 | September 19th, 2003 09:40 PM |