Hi All,

I have a couple of queries regarding the settings and properties of a line chart. Can anyone help?



I have a line chart to display some data but the settings keep changing to default, I want the missing data policy to always be 'Plot As Interpolated' but whenever I switch data (chart displays different data based on a combobox) it changes back to 'Do Not Plot'. Is there a way to save chart settings to stop them defaulting?

The default y-axis 'Primary Values Axis' also drops down to zero sometimes, which is way below my data so doesn't make it properly visible. Can I link min and mix primary values axis to be based on an input or calculation in a textbox? The property sheet only appears to allow numeric values and not link to a textbox.

Thanks,
RB