missing data and line graph

Charmed

New Member
Joined
Oct 6, 2006
Messages
16
Hi, I have typed #N/A in cells where data was not available.
Now I want to pull a chart but I want the line chart to not show the missing data but show a continuous line.

I know it can be done but I can't recall exactly.

Thanks in advance.

Rebecca
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

Charmed

New Member
Joined
Oct 6, 2006
Messages
16
Thanks so much for your help regarding this. I will proceed to follow what you said. It seems pretty straight forward. If I have any troubles I'm sure I'll have to ask you another question. But it seems okay.

Thanks again.

Rebecca
 

Charmed

New Member
Joined
Oct 6, 2006
Messages
16
HI, I'm trying to do the above but I don't have any experience entering formulas into the chart source area. I know how to select a source range but where do I put the formula?

Thanks in advance!
 

Jon Peltier

MrExcel MVP
Joined
May 14, 2003
Messages
4,966
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS

ADVERTISEMENT

The formula goes in the cells that contain the data. The chart source can only contain linking formulas, not calculating formulas.

If you already have #N/A in the cells, it should let the line continue over the gap. Did you try it?
 

tusharm

MrExcel MVP
Joined
May 28, 2002
Messages
11,029
If you typed in #N/A, or =NA(), XL should automatically draw a line through the missing data point. What is it doing now?

Alternatively, if you leave the cell blank (no formula, no text, no nothing), you have a choice of how XL treats missing data. Create the chart, then select the chart and select Tools | Options... | Chart tab. In the Active Chart section, set the 'Plot empty cells as' option to 'Interpolated'.


Hi, I have typed #N/A in cells where data was not available.
Now I want to pull a chart but I want the line chart to not show the missing data but show a continuous line.

I know it can be done but I can't recall exactly.

Thanks in advance.

Rebecca
 

Charmed

New Member
Joined
Oct 6, 2006
Messages
16
Solved problem

Hi I solved the problem. You're right...I didn't need the formula. Human error was involved. :)

Charmed
 

Forum statistics

Threads
1,136,612
Messages
5,676,796
Members
419,651
Latest member
alexanderguhr

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top