| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
making the chart disapear when there is no text
I have to create a chart that gets updated daily. I need to create a formula
to calculate the % of our daily sales. What I wanted to do was put the formula in in advance and then just enter in our daily sales so it would automatically calculate the percentages. But when I do this The chart line goes acros the month at zero. I have tried the IF formulas for if f5="","" and it still occurs. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
making the chart disapear when there is no text
Hi,
Rather than "" use NA() =IF(F5="",NA(),F5) Cheers Andy Erin Leva wrote: I have to create a chart that gets updated daily. I need to create a formula to calculate the % of our daily sales. What I wanted to do was put the formula in in advance and then just enter in our daily sales so it would automatically calculate the percentages. But when I do this The chart line goes acros the month at zero. I have tried the IF formulas for if f5="","" and it still occurs. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| making a chart | Excel Discussion (Misc queries) | |||
| Making a chart | Charts and Charting in Excel | |||
| making a chart | Excel Discussion (Misc queries) | |||
| Chart making | Charts and Charting in Excel | |||
| Making a chart | Charts and Charting in Excel | |||
![Erin Leva[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
