Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to indicate that a value is an estimate?
Does anyone know a way to indicate an estimated value in Excel? I have a
chart of weight loss progress, where I weigh myself weekly. Some weeks I forget (!) to weigh myself, and I don't want the chart to suddenly drop to zero for that week, but I want to be able to indicate that the value entered for that week is an estimate, not an actual recorded weight. Is there a way to do this? Thanks for any help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to indicate that a value is an estimate?
If you choose a line chart with bullets, you will get a marker at each data
point. Then choose Tools Opetions ChartTab PlotEmptyCellsAs and check the "Interpolated box..........this will continue the line between weighings, yet not insert a bullet for the "estimated" weights. hth Vaya con Dios, Chuck, CABGx3 "couture57" wrote: Does anyone know a way to indicate an estimated value in Excel? I have a chart of weight loss progress, where I weigh myself weekly. Some weeks I forget (!) to weigh myself, and I don't want the chart to suddenly drop to zero for that week, but I want to be able to indicate that the value entered for that week is an estimate, not an actual recorded weight. Is there a way to do this? Thanks for any help. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to indicate that a value is an estimate?
couture57,
Instead of putting in an estimate, you can leave the cells empty, and set the chart to skip the empty points, and not drop to 0. With the chart selected (necessary if there's more than one chart), Tools - Options - Chart tab - Plot empty cells as; Interpolated. Or you can set it to "Leave gaps" if you perfer. No one knows why some chart settings are in Tools - Options, and others are in the Chart menu. No one. Perhaps the Unified Theory, if we ever get it, will tell us. -- Earl Kiosterud www.smokeylake.com ----------------------------------------------------------------------- "couture57" wrote in message ... Does anyone know a way to indicate an estimated value in Excel? I have a chart of weight loss progress, where I weigh myself weekly. Some weeks I forget (!) to weigh myself, and I don't want the chart to suddenly drop to zero for that week, but I want to be able to indicate that the value entered for that week is an estimate, not an actual recorded weight. Is there a way to do this? Thanks for any help. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to indicate that a value is an estimate?
Thanks to both of you - that is exactly the information I was looking for!
"Earl Kiosterud" wrote: couture57, Instead of putting in an estimate, you can leave the cells empty, and set the chart to skip the empty points, and not drop to 0. With the chart selected (necessary if there's more than one chart), Tools - Options - Chart tab - Plot empty cells as; Interpolated. Or you can set it to "Leave gaps" if you perfer. No one knows why some chart settings are in Tools - Options, and others are in the Chart menu. No one. Perhaps the Unified Theory, if we ever get it, will tell us. -- Earl Kiosterud www.smokeylake.com ----------------------------------------------------------------------- "couture57" wrote in message ... Does anyone know a way to indicate an estimated value in Excel? I have a chart of weight loss progress, where I weigh myself weekly. Some weeks I forget (!) to weigh myself, and I don't want the chart to suddenly drop to zero for that week, but I want to be able to indicate that the value entered for that week is an estimate, not an actual recorded weight. Is there a way to do this? Thanks for any help. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to indicate that a value is an estimate?
Happy to help............thanks for the feedback.
Vaya con Dios, Chuck, CABGx3 "couture57" wrote: Thanks to both of you - that is exactly the information I was looking for! "Earl Kiosterud" wrote: couture57, Instead of putting in an estimate, you can leave the cells empty, and set the chart to skip the empty points, and not drop to 0. With the chart selected (necessary if there's more than one chart), Tools - Options - Chart tab - Plot empty cells as; Interpolated. Or you can set it to "Leave gaps" if you perfer. No one knows why some chart settings are in Tools - Options, and others are in the Chart menu. No one. Perhaps the Unified Theory, if we ever get it, will tell us. -- Earl Kiosterud www.smokeylake.com ----------------------------------------------------------------------- "couture57" wrote in message ... Does anyone know a way to indicate an estimated value in Excel? I have a chart of weight loss progress, where I weigh myself weekly. Some weeks I forget (!) to weigh myself, and I don't want the chart to suddenly drop to zero for that week, but I want to be able to indicate that the value entered for that week is an estimate, not an actual recorded weight. Is there a way to do this? Thanks for any help. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to indicate that a value is an estimate?
"CLR" wrote: If you choose a line chart with bullets, you will get a marker at each data point. Then choose Tools Opetions ChartTab PlotEmptyCellsAs and check the "Interpolated box..........this will continue the line between weighings, yet not insert a bullet for the "estimated" weights. hth Vaya con Dios, Chuck, CABGx3 "couture57" wrote: Does anyone know a way to indicate an estimated value in Excel? I have a chart of weight loss progress, where I weigh myself weekly. Some weeks I forget (!) to weigh myself, and I don't want the chart to suddenly drop to zero for that week, but I want to be able to indicate that the value entered for that week is an estimate, not an actual recorded weight. Is there a way to do this? Thanks for any help. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to indicate that a value is an estimate?
"couture57" wrote: Thanks to both of you - that is exactly the information I was looking for! "Earl Kiosterud" wrote: couture57, Instead of putting in an estimate, you can leave the cells empty, and set the chart to skip the empty points, and not drop to 0. With the chart selected (necessary if there's more than one chart), Tools - Options - Chart tab - Plot empty cells as; Interpolated. Or you can set it to "Leave gaps" if you perfer. No one knows why some chart settings are in Tools - Options, and others are in the Chart menu. No one. Perhaps the Unified Theory, if we ever get it, will tell us. -- Earl Kiosterud www.smokeylake.com ----------------------------------------------------------------------- "couture57" wrote in message ... Does anyone know a way to indicate an estimated value in Excel? I have a chart of weight loss progress, where I weigh myself weekly. Some weeks I forget (!) to weigh myself, and I don't want the chart to suddenly drop to zero for that week, but I want to be able to indicate that the value entered for that week is an estimate, not an actual recorded weight. Is there a way to do this? Thanks for any help. |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to indicate that a value is an estimate?
"couture57" wrote: Does anyone know a way to indicate an estimated value in Excel? I have a chart of weight loss progress, where I weigh myself weekly. Some weeks I forget (!) to weigh myself, and I don't want the chart to suddenly drop to zero for that week, but I want to be able to indicate that the value entered for that week is an estimate, not an actual recorded weight. Is there a way to do this? Thanks for any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to set up a cost estimate spreadsheet? | Excel Worksheet Functions | |||
How to use miles per hour and mileage to estimate travel time | Excel Worksheet Functions | |||
How to estimate a future service date? | Excel Worksheet Functions | |||
Template for estimate | Excel Discussion (Misc queries) | |||
Commercial Construction Cost Breakdown Estimate Sheet | Excel Discussion (Misc queries) |