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
|
|||
|
|||
Excel chart - result of formula = " " don't want to see in chart
I have built a simple line graph, showing last year sale figures, this
years budget and this years actuals. I have 12 months worth of data for the first two categories, but only two months for actuals. The problem I have is that the data for the graph is being taken from a table which gets its information from a larger data block using a lookup function. The problem I have is that the data for actuals includes a number for January and February but nothing for March onwards. To insure that there is nothing there I have used an if funtion to return a " " if there is no number or the number itself if there is. The chart shows the " " as a zero, but all I want to see is a line representing January and February. I know this is probably a really basic thing but I just can't find the answer. HELP!!! Thanks Simon --- Message posted from http://www.ExcelForum.com/ |
#2
|
|||
|
|||
Excel chart - result of formula = " " don't want to see in chart
Hi
try changing your IF function to something liek =IF(a1"",A1,NA()) so instead of returning " " return NA() you may use conditional formating to hide these output (use a white font color for this) -- Regards Frank Kabel Frankfurt, Germany I have built a simple line graph, showing last year sale figures, this years budget and this years actuals. I have 12 months worth of data for the first two categories, but only two months for actuals. The problem I have is that the data for the graph is being taken from a table which gets its information from a larger data block using a lookup function. The problem I have is that the data for actuals includes a number for January and February but nothing for March onwards. To insure that there is nothing there I have used an if funtion to return a " " if there is no number or the number itself if there is. The chart shows the " " as a zero, but all I want to see is a line representing January and February. I know this is probably a really basic thing but I just can't find the answer. HELP!!! Thanks Simon --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | |
Display Modes | |
|
|