Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Eliminating "tails" on line charts
I am utilizing the line chart option in generating a personal weight loss
chart within Excel. Therefore, the graph has weight on the vertical axis and time on the horizontal axis. The weight entries have "holes" in the data due to some days of no data entered. I want the line graph to have discontinuity durin the days where no data was entered. To clarify, I want the line graph to be continuous up to the day where no data was entered, the graph will have no data points or lines on the days where the data is missing, then the graph will start again on the next data entry. When I use a single row data array as the data series, the line graph does show a break in the line of continuous data, however Excel graphs a vertical line down to zero at every stopping data point, then a vertical line from zero up to the appropriate value when the data starts again. I call these "tails" on the graph. Is there any way to eliminate these "tails"? I found out that, when charting a data series of manually entered data, the absence of data resulted in no tail. However, when charting a data series of data where formulas generated the data, the tails appear. I must state that the formulae have "IF(...)" functions within them. The false action executes the empty quotes "" for data holes. Please assist. THANKS!!! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Eliminating "tails" on line charts
Try changing your formula to give NA() instead of "".
-- David Biddulph "Skyscan" wrote in message ... I am utilizing the line chart option in generating a personal weight loss chart within Excel. Therefore, the graph has weight on the vertical axis and time on the horizontal axis. The weight entries have "holes" in the data due to some days of no data entered. I want the line graph to have discontinuity durin the days where no data was entered. To clarify, I want the line graph to be continuous up to the day where no data was entered, the graph will have no data points or lines on the days where the data is missing, then the graph will start again on the next data entry. When I use a single row data array as the data series, the line graph does show a break in the line of continuous data, however Excel graphs a vertical line down to zero at every stopping data point, then a vertical line from zero up to the appropriate value when the data starts again. I call these "tails" on the graph. Is there any way to eliminate these "tails"? I found out that, when charting a data series of manually entered data, the absence of data resulted in no tail. However, when charting a data series of data where formulas generated the data, the tails appear. I must state that the formulae have "IF(...)" functions within them. The false action executes the empty quotes "" for data holes. Please assist. THANKS!!! |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Eliminating "tails" on line charts
Thank you VERY much David!!! This worked great for me!!!
Best Regards, Tom Normand "David Biddulph" wrote: Try changing your formula to give NA() instead of "". -- David Biddulph "Skyscan" wrote in message ... I am utilizing the line chart option in generating a personal weight loss chart within Excel. Therefore, the graph has weight on the vertical axis and time on the horizontal axis. The weight entries have "holes" in the data due to some days of no data entered. I want the line graph to have discontinuity durin the days where no data was entered. To clarify, I want the line graph to be continuous up to the day where no data was entered, the graph will have no data points or lines on the days where the data is missing, then the graph will start again on the next data entry. When I use a single row data array as the data series, the line graph does show a break in the line of continuous data, however Excel graphs a vertical line down to zero at every stopping data point, then a vertical line from zero up to the appropriate value when the data starts again. I call these "tails" on the graph. Is there any way to eliminate these "tails"? I found out that, when charting a data series of manually entered data, the absence of data resulted in no tail. However, when charting a data series of data where formulas generated the data, the tails appear. I must state that the formulae have "IF(...)" functions within them. The false action executes the empty quotes "" for data holes. Please assist. THANKS!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you select line or columns in "Line-Column on 2 axes" graphs? | Excel Discussion (Misc queries) | |||
Eliminating the quote "This document was sent to the printer" | Excel Discussion (Misc queries) | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
select & format "single" axis line in charts | Charts and Charting in Excel |