Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Plot empty cells as: Interpolated
Hi All
I have two columns (Data 1 and Data 2) that need to be consolidated (Result Column) Example: Data 1 Data 2 Result 1 6 7 2 7 9 5 9 14 6 10 16 9 19 28 I consolidated the data columns using the following formula: =IF(AND(ISBLANK(B3),ISBLANK(C3)),"",B3+C3) When a graph is created for the result column the graph return to zero at each "empty" cell. Could anyone please help to solve the problem. |
#2
|
|||
|
|||
Hi,
for charting use NA() =IF(AND(ISBLANK(B3),ISBLANK(C3)),NA(),B3+C3) Cheers Andy Jaco wrote: Hi All I have two columns (Data 1 and Data 2) that need to be consolidated (Result Column) Example: Data 1 Data 2 Result 1 6 7 2 7 9 5 9 14 6 10 16 9 19 28 I consolidated the data columns using the following formula: =IF(AND(ISBLANK(B3),ISBLANK(C3)),"",B3+C3) When a graph is created for the result column the graph return to zero at each "empty" cell. Could anyone please help to solve the problem. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
|
|||
|
|||
Either use #N/A instead of "" for blank cells or delete the formula
where "blank". Jerry Jaco wrote: Hi All I have two columns (Data 1 and Data 2) that need to be consolidated (Result Column) Example: Data 1 Data 2 Result 1 6 7 2 7 9 5 9 14 6 10 16 9 19 28 I consolidated the data columns using the following formula: =IF(AND(ISBLANK(B3),ISBLANK(C3)),"",B3+C3) When a graph is created for the result column the graph return to zero at each "empty" cell. Could anyone please help to solve the problem. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ignoring empty cells | Excel Discussion (Misc queries) | |||
In Bar Chart, can we display both figures and their respective %a. | Excel Discussion (Misc queries) | |||
To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
empty cells in ranges | Excel Discussion (Misc queries) |