Chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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