| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Blank Cells
I have a chart that list a line graph for each month. The problem I am
having is that since I don't have data for the other half of the year the graph will drop down to 0. I could just modify the range but I am trying to automate this chart. I was wondering if there is a macro that will delete blank cells in a range even if they have GETPIVOT function but does not return any value? -- T |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Index/match - make blank cells return a blank value. | Excel Worksheet Functions | |||
| Need Array Formula for Counting Blank & Non Blank Cells (Multiple Criteria) | Excel Discussion (Misc queries) | |||
| Maximum Number of Blank Cells between Non Blank Cells in a Range | Excel Worksheet Functions | |||
| Start Cell B1 then find first blank cell, insert subtotal, next non blank, then next blank, sutotal cells in between......... | Excel Programming | |||
| Copy to first Blank cell in Colum C Non blank cells still exist be | Excel Programming | |||
Threaded Mode
