Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Getting a line chart to NOT plot a zero value
I have a chart that is updated each month with new production figures and a
line chart set up to automatically pull the data from the chart and plot it; however, on the months that haven't occurred yet, the line chart is plotting those months as "zero". I've tried setting the "plot empty cells as: not plotted" in tools/options/chart, but that doesn't work. Apparently, because there is a formula in the cell for the future months, it is plotting the zero... What am I missing?! Thanks a ton!! |
#2
|
|||
|
|||
Formulas must return something. "" (which they presumably now return
for future months) is not equivalent to an empty cell. All text plots as zero. Either delete the formulas until they are needed (they could be restored automatically by a worksheet change event) or use #N/A instead of "" for future months. Jerry sheryl wrote: I have a chart that is updated each month with new production figures and a line chart set up to automatically pull the data from the chart and plot it; however, on the months that haven't occurred yet, the line chart is plotting those months as "zero". I've tried setting the "plot empty cells as: not plotted" in tools/options/chart, but that doesn't work. Apparently, because there is a formula in the cell for the future months, it is plotting the zero... What am I missing?! Thanks a ton!! |
#3
|
|||
|
|||
Thanks, Jerry!
I ended up just moving the future formulas out of the chart data range and I'll move them back in each month. "Jerry W. Lewis" wrote: Formulas must return something. "" (which they presumably now return for future months) is not equivalent to an empty cell. All text plots as zero. Either delete the formulas until they are needed (they could be restored automatically by a worksheet change event) or use #N/A instead of "" for future months. Jerry sheryl wrote: I have a chart that is updated each month with new production figures and a line chart set up to automatically pull the data from the chart and plot it; however, on the months that haven't occurred yet, the line chart is plotting those months as "zero". I've tried setting the "plot empty cells as: not plotted" in tools/options/chart, but that doesn't work. Apparently, because there is a formula in the cell for the future months, it is plotting the zero... What am I missing?! Thanks a ton!! |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Getting a line chart to NOT plot a zero value
#N/A works great... thanks
"sheryl" wrote: Thanks, Jerry! I ended up just moving the future formulas out of the chart data range and I'll move them back in each month. "Jerry W. Lewis" wrote: Formulas must return something. "" (which they presumably now return for future months) is not equivalent to an empty cell. All text plots as zero. Either delete the formulas until they are needed (they could be restored automatically by a worksheet change event) or use #N/A instead of "" for future months. Jerry sheryl wrote: I have a chart that is updated each month with new production figures and a line chart set up to automatically pull the data from the chart and plot it; however, on the months that haven't occurred yet, the line chart is plotting those months as "zero". I've tried setting the "plot empty cells as: not plotted" in tools/options/chart, but that doesn't work. Apparently, because there is a formula in the cell for the future months, it is plotting the zero... What am I missing?! Thanks a ton!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combination of stock chart and line chart | Charts and Charting in Excel | |||
Creating a line chart with two X-axes!! | Excel Discussion (Misc queries) | |||
I want to draw a line through the columns of a chart, plot the o. | Charts and Charting in Excel | |||
Line chart - date line association gone mad! | Charts and Charting in Excel | |||
pivot table multi line chart | Charts and Charting in Excel |