Chart

J

Jose Perdigao

I have a trend and when I don't have values, doesn't show nothing. How can I
interpolated the values that is missing?
In MS Excel I can do but in access I don't see where I can setup the chart
to show the interpolated values.

Thanks
Jose
 
F

fredg

I have a trend and when I don't have values, doesn't show nothing. How can I
interpolated the values that is missing?
In MS Excel I can do but in access I don't see where I can setup the chart
to show the interpolated values.

Thanks
Jose
Click to expand...

In Design View, right-click on the chart.
Select Chart Object + Edit.
Click Tools + Options + Chart tab.
In the Empty Cells Plotted As group check the option you want.
 
J

Jose Perdigao

Thanks Freg.


fredg said:
In Design View, right-click on the chart.
Select Chart Object + Edit.
Click Tools + Options + Chart tab.
In the Empty Cells Plotted As group check the option you want.
Click to expand...
 
Top