missing data points causes my line graph not to connect
 

Hi there,

I am doing a simple line graph for data points over 200 days, however for
some of the days I do not have data, therefore when I create a graph it where
there is missing data the line does not connect, there should be an easy way
to fix it, but I can't figure it out. I tried to just select the data I want
in the series but it only holds so many and I can't get all the data points
in.

Please help

Tools menu Options Chart tab. Choose the interpolation option for
how Excel should treat a blank cell.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


liebw wrote:

Hi there,

I am doing a simple line graph for data points over 200 days, however for
some of the days I do not have data, therefore when I create a graph it where
there is missing data the line does not connect, there should be an easy way
to fix it, but I can't figure it out. I tried to just select the data I want
in the series but it only holds so many and I can't get all the data points
in.

Please help

If the cells are empty, then Tools|Options|Chart and check the option to
Interpolate missing values. If the cells contain formulas, then have
them return #N/A for missing values.

Jerry

liebw wrote:

Hi there,

I am doing a simple line graph for data points over 200 days, however for
some of the days I do not have data, therefore when I create a graph it where
there is missing data the line does not connect, there should be an easy way
to fix it, but I can't figure it out. I tried to just select the data I want
in the series but it only holds so many and I can't get all the data points
in.

Please help

I've been using an extremely useful free add-in by Tushar Mehta; you can
download it from
http://www.tushar-mehta.com/excel/so...tinuity/--just replace
missing points with cell values =na()'s.

z.entropic

"liebw" wrote:

Hi there,

I am doing a simple line graph for data points over 200 days, however for
some of the days I do not have data, therefore when I create a graph it where
there is missing data the line does not connect, there should be an easy way
to fix it, but I can't figure it out. I tried to just select the data I want
in the series but it only holds so many and I can't get all the data points
in.

Please help

Thank you so much!!!!!!!!!
I have been working on this stupid thing for so long, I knew there had to be
an easier answer and it was driving me crazy that I couldn't figure it out.
Thanks again

"Jerry W. Lewis" wrote:

If the cells are empty, then Tools|Options|Chart and check the option to
Interpolate missing values. If the cells contain formulas, then have
them return #N/A for missing values.

Jerry

liebw wrote:

Hi there,

I am doing a simple line graph for data points over 200 days, however for
some of the days I do not have data, therefore when I create a graph it where
there is missing data the line does not connect, there should be an easy way
to fix it, but I can't figure it out. I tried to just select the data I want
in the series but it only holds so many and I can't get all the data points
in.

Please help

Thank you so much!!!!!!!!!
I have been working on this stupid thing for so long, I knew there had to be
an easier answer and it was driving me crazy that I couldn't figure it out.
Thanks again

"Jon Peltier" wrote:

Tools menu Options Chart tab. Choose the interpolation option for
how Excel should treat a blank cell.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


liebw wrote:

Hi there,

I am doing a simple line graph for data points over 200 days, however for
some of the days I do not have data, therefore when I create a graph it where
there is missing data the line does not connect, there should be an easy way
to fix it, but I can't figure it out. I tried to just select the data I want
in the series but it only holds so many and I can't get all the data points
in.

Please help

You're welcome. Glad it helped.

Jerry

liebw wrote:

Thank you so much!!!!!!!!!
I have been working on this stupid thing for so long, I knew there had to be
an easier answer and it was driving me crazy that I couldn't figure it out.
Thanks again

missing data points causes my line graph not to connect
 

Does anyone know how to do this in the 2007 version of Excel?

"Jerry W. Lewis" wrote:

If the cells are empty, then Tools|Options|Chart and check the option to
Interpolate missing values. If the cells contain formulas, then have
them return #N/A for missing values.

Jerry

liebw wrote:

Hi there,

I am doing a simple line graph for data points over 200 days, however for
some of the days I do not have data, therefore when I create a graph it where
there is missing data the line does not connect, there should be an easy way
to fix it, but I can't figure it out. I tried to just select the data I want
in the series but it only holds so many and I can't get all the data points
in.

Please help

missing data points causes my line graph not to connect
 

Found the answer by good ol' trial-and-error...

In Excel 2007:
- Select the plot area of the chart
- Right click and go to "Select Data"
- Click "Hidden and Empty cells" in the bottom left corner of the Select
Data Source box
- For 'Show empty cells as:' select "Connect data points with line"


"Whitney" wrote:

Does anyone know how to do this in the 2007 version of Excel?

"Jerry W. Lewis" wrote:

If the cells are empty, then Tools|Options|Chart and check the option to
Interpolate missing values. If the cells contain formulas, then have
them return #N/A for missing values.

Jerry

liebw wrote:

Hi there,

I am doing a simple line graph for data points over 200 days, however for
some of the days I do not have data, therefore when I create a graph it where
there is missing data the line does not connect, there should be an easy way
to fix it, but I can't figure it out. I tried to just select the data I want
in the series but it only holds so many and I can't get all the data points
in.

Please help