Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
#7
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#9
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to add data points to a scatter plot with trend line | Charts and Charting in Excel | |||
Help making a chart that doesn't graph cells without data? | Excel Discussion (Misc queries) | |||
REPOST: How can I make the graph omit blank cells in the data set? | Charts and Charting in Excel | |||
Limiting Data Obatined By A Graph From A Spread Sheed | Charts and Charting in Excel | |||
create space in line chart between points, linked to pivot table | Charts and Charting in Excel |