Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Gaps in Line Chart
I have a line chart wherein my data for the line is in A1:A100...
and my data for the date is B1:B100 NO PROBLEM Every 15 days, i.e. in rows A15:A17, B15:B17 A32:A35, B32:B35...etc. I have gaps in my data for informational purposes (in other words, I have headers for the columns, such as DATE, VALUE, AVERAGE, etc.) At present, my chart is an unbroken line...i.e., the gaps are as if they weren't there. However, now when I extend my "SOURCE DATA" TO INCLUDE MORE ROWS AS FOLLOWS: Data in A1:A150 B1:B150 NOW, MY CHART LINE HAS GAPS IN IT every 15 rows of data. Is it possible to OMIT these gaps without "SOURCE DATA" in partials as (A1:A15,A18:A31, etc...)? I hope this is understandable. Basically, at present, my chart has an unbroken line, eventhough there are gaps in the data...(non-numerical rows). But, as soon as I extend the Source Data beyond my A100, all the line gaps appear!!! Can this be avoided? Thanks, FLKulchar |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Gaps in Line Chart
If the gaps are due to blank cells, select the chart, go to the Tools menu,
click on the Chart tab, and choose Interpolate near the top for how Excel should deal with blank cells. You have to set this for each chart. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "F. Lawrence Kulchar" wrote in message ... I have a line chart wherein my data for the line is in A1:A100... and my data for the date is B1:B100 NO PROBLEM Every 15 days, i.e. in rows A15:A17, B15:B17 A32:A35, B32:B35...etc. I have gaps in my data for informational purposes (in other words, I have headers for the columns, such as DATE, VALUE, AVERAGE, etc.) At present, my chart is an unbroken line...i.e., the gaps are as if they weren't there. However, now when I extend my "SOURCE DATA" TO INCLUDE MORE ROWS AS FOLLOWS: Data in A1:A150 B1:B150 NOW, MY CHART LINE HAS GAPS IN IT every 15 rows of data. Is it possible to OMIT these gaps without "SOURCE DATA" in partials as (A1:A15,A18:A31, etc...)? I hope this is understandable. Basically, at present, my chart has an unbroken line, eventhough there are gaps in the data...(non-numerical rows). But, as soon as I extend the Source Data beyond my A100, all the line gaps appear!!! Can this be avoided? Thanks, FLKulchar |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Gaps in Line Chart
The gaps are NOT due to blank cells -- they are due to non-numeric (alpha)
cells. Please RSVP, FLKulchar "Jon Peltier" wrote in message ... If the gaps are due to blank cells, select the chart, go to the Tools menu, click on the Chart tab, and choose Interpolate near the top for how Excel should deal with blank cells. You have to set this for each chart. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "F. Lawrence Kulchar" wrote in message ... I have a line chart wherein my data for the line is in A1:A100... and my data for the date is B1:B100 NO PROBLEM Every 15 days, i.e. in rows A15:A17, B15:B17 A32:A35, B32:B35...etc. I have gaps in my data for informational purposes (in other words, I have headers for the columns, such as DATE, VALUE, AVERAGE, etc.) At present, my chart is an unbroken line...i.e., the gaps are as if they weren't there. However, now when I extend my "SOURCE DATA" TO INCLUDE MORE ROWS AS FOLLOWS: Data in A1:A150 B1:B150 NOW, MY CHART LINE HAS GAPS IN IT every 15 rows of data. Is it possible to OMIT these gaps without "SOURCE DATA" in partials as (A1:A15,A18:A31, etc...)? I hope this is understandable. Basically, at present, my chart has an unbroken line, eventhough there are gaps in the data...(non-numerical rows). But, as soon as I extend the Source Data beyond my A100, all the line gaps appear!!! Can this be avoided? Thanks, FLKulchar |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Gaps in Line Chart
You will need to delete the text entries.
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "FLKulchar" wrote in message ... The gaps are NOT due to blank cells -- they are due to non-numeric (alpha) cells. Please RSVP, FLKulchar "Jon Peltier" wrote in message ... If the gaps are due to blank cells, select the chart, go to the Tools menu, click on the Chart tab, and choose Interpolate near the top for how Excel should deal with blank cells. You have to set this for each chart. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "F. Lawrence Kulchar" wrote in message ... I have a line chart wherein my data for the line is in A1:A100... and my data for the date is B1:B100 NO PROBLEM Every 15 days, i.e. in rows A15:A17, B15:B17 A32:A35, B32:B35...etc. I have gaps in my data for informational purposes (in other words, I have headers for the columns, such as DATE, VALUE, AVERAGE, etc.) At present, my chart is an unbroken line...i.e., the gaps are as if they weren't there. However, now when I extend my "SOURCE DATA" TO INCLUDE MORE ROWS AS FOLLOWS: Data in A1:A150 B1:B150 NOW, MY CHART LINE HAS GAPS IN IT every 15 rows of data. Is it possible to OMIT these gaps without "SOURCE DATA" in partials as (A1:A15,A18:A31, etc...)? I hope this is understandable. Basically, at present, my chart has an unbroken line, eventhough there are gaps in the data...(non-numerical rows). But, as soon as I extend the Source Data beyond my A100, all the line gaps appear!!! Can this be avoided? Thanks, FLKulchar |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Gaps in Line Chart
thank you
FLKulchar "Bernard Liengme" wrote in message ... You will need to delete the text entries. -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "FLKulchar" wrote in message ... The gaps are NOT due to blank cells -- they are due to non-numeric (alpha) cells. Please RSVP, FLKulchar "Jon Peltier" wrote in message ... If the gaps are due to blank cells, select the chart, go to the Tools menu, click on the Chart tab, and choose Interpolate near the top for how Excel should deal with blank cells. You have to set this for each chart. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "F. Lawrence Kulchar" wrote in message ... I have a line chart wherein my data for the line is in A1:A100... and my data for the date is B1:B100 NO PROBLEM Every 15 days, i.e. in rows A15:A17, B15:B17 A32:A35, B32:B35...etc. I have gaps in my data for informational purposes (in other words, I have headers for the columns, such as DATE, VALUE, AVERAGE, etc.) At present, my chart is an unbroken line...i.e., the gaps are as if they weren't there. However, now when I extend my "SOURCE DATA" TO INCLUDE MORE ROWS AS FOLLOWS: Data in A1:A150 B1:B150 NOW, MY CHART LINE HAS GAPS IN IT every 15 rows of data. Is it possible to OMIT these gaps without "SOURCE DATA" in partials as (A1:A15,A18:A31, etc...)? I hope this is understandable. Basically, at present, my chart has an unbroken line, eventhough there are gaps in the data...(non-numerical rows). But, as soon as I extend the Source Data beyond my A100, all the line gaps appear!!! Can this be avoided? Thanks, FLKulchar |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart Type - Line Column adding a 2nd line | Charts and Charting in Excel | |||
Line chart with one value extrememly high | Charts and Charting in Excel | |||
tick mark labels | Charts and Charting in Excel | |||
Line chart in Excel - trendline incomplete | Charts and Charting in Excel | |||
Line chart - date line association gone mad! | Charts and Charting in Excel |