Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How can I get the zero values at the end of a chart not to show?
I have a chart getting data from a spreadsheet, where data is added one day
at a time, for an entire month. After adding the data for the first day, the data point shows, but the line connecting the data point in the chart immediately drops to zero, since data for the remaining days is not available. Is there a way to just have the line connecting the data points show only where there is data, and not show anything for the upcoming days where data is not available? Thanks. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How can I get the zero values at the end of a chart not to show?
1) use a dynamic chart - see
http://www.stfx.ca/people/bliengme/E...ps/Dynamic.htm or 2) rather than blanks for missing data use =NA() or 3) click on chart and use Tools|Options, open CHART tab, check the option Plot empty cell as - not plotted best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "wabmreo" wrote in message ... I have a chart getting data from a spreadsheet, where data is added one day at a time, for an entire month. After adding the data for the first day, the data point shows, but the line connecting the data point in the chart immediately drops to zero, since data for the remaining days is not available. Is there a way to just have the line connecting the data points show only where there is data, and not show anything for the upcoming days where data is not available? Thanks. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
How can I get the zero values at the end of a chart not to sho
The formula that is in the link below (option 1), once I entered it into the
INSERT/NAME/DEFINE box, is not being recognized as a range, so when I modify the series it won't accept it... It SHOULD recognize it as a range, correct? thanks "Bernard Liengme" wrote: 1) use a dynamic chart - see http://www.stfx.ca/people/bliengme/E...ps/Dynamic.htm or 2) rather than blanks for missing data use =NA() or 3) click on chart and use Tools|Options, open CHART tab, check the option Plot empty cell as - not plotted best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "wabmreo" wrote in message ... I have a chart getting data from a spreadsheet, where data is added one day at a time, for an entire month. After adding the data for the first day, the data point shows, but the line connecting the data point in the chart immediately drops to zero, since data for the remaining days is not available. Is there a way to just have the line connecting the data points show only where there is data, and not show anything for the upcoming days where data is not available? Thanks. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
How can I get the zero values at the end of a chart not to sho
Try =SERIES(Sheet1!$B$1,Dynamic.xls!date,Dynamic.xls!s ales,1)
where Dynamic!.xsl is the name of the file from a previous save. -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "wabmreo" wrote in message ... The formula that is in the link below (option 1), once I entered it into the INSERT/NAME/DEFINE box, is not being recognized as a range, so when I modify the series it won't accept it... It SHOULD recognize it as a range, correct? thanks "Bernard Liengme" wrote: 1) use a dynamic chart - see http://www.stfx.ca/people/bliengme/E...ps/Dynamic.htm or 2) rather than blanks for missing data use =NA() or 3) click on chart and use Tools|Options, open CHART tab, check the option Plot empty cell as - not plotted best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "wabmreo" wrote in message ... I have a chart getting data from a spreadsheet, where data is added one day at a time, for an entire month. After adding the data for the first day, the data point shows, but the line connecting the data point in the chart immediately drops to zero, since data for the remaining days is not available. Is there a way to just have the line connecting the data points show only where there is data, and not show anything for the upcoming days where data is not available? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Only chart certain values | Charts and Charting in Excel | |||
How do I show the Grand Total on a Pivot Chart? | Charts and Charting in Excel | |||
Scatter chart without numerical values | Charts and Charting in Excel | |||
How to assign character (text) values to y-axis in a Excel chart? | Charts and Charting in Excel | |||
Create new series (on the same chart) for every change of values in a combobox | Charts and Charting in Excel |