Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am using Microsoft 2003.
Is there a forumla that will force a zero value to be either null or blank? I am taking a list from Excel and importing it into Business Objects and creating a chart. If the value is zero, it creates a zero line on my graph. If the value is blank, it doesn't display. I've tried doing a forumla that says if the value is 0 return "" but that doesn't work for what I want to do. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Chart values for blanks show as zero (Excel 2003) | Charts and Charting in Excel | |||
converting hourly values into daily values | Excel Worksheet Functions | |||
Paste Special as Values: no recognition of blanks | Excel Discussion (Misc queries) | |||
Replace values in shaded cells with blanks | Excel Discussion (Misc queries) | |||
If Then, not using values, or not counting blanks | Excel Worksheet Functions |