# Plot empty cells as: Interpolated

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.

2. ## Re: Plot empty cells as: Interpolated

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.
>

3. ## Re: Plot empty cells as: Interpolated

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.
>

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1