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.
|