| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Using Formulas with Charts
I have a chart that references cells with the following formula
=if(a1="","",a1/a2). The formula is used for each month Jan-Dec. I would like to copy the formula across all months. When I do this my data point show as zero for months that have not happened yet. What can I do to not show a line on the chart for a data point with a "" or null value? Thank you, Sandy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Logarithmic curve formulas in charts and LOGEST fx values? | Excel Worksheet Functions | |||
| need a refresher: text boxes on charts that use relational formulas? | Charts and Charting in Excel | |||
| FORMULAS IN CHARTS? xl2000 | Charts and Charting in Excel | |||
| linkingof charts in worksheets to cells | Excel Discussion (Misc queries) | |||
| calculating formulas for all workbooks in a folder | Excel Worksheet Functions | |||
Threaded Mode
