Incorrect format in datasheet

[Lucas]

I have a chart that shows a bunch of percentage values at different periods in time, nothing special. However, when I add a datasheet the values are regular numbers instead of percentages. I have changed the format in the datasheet (which corrects the values in design mode, but not in preview) and if I change it in the query that the chart is based on it changes the format back to undefined once I exit design mode.

Can anybody help me out?

Thanks.

Lucas

 

[Lucas]

Okay well I figured it out, Format(FieldName,"percent").

I now have a new problem, I have two series of percentage values, and I'd like to see them in a column - line chart with two axes (with two other series for columns). Unfortunately I can't seem to get two lines in the chart.

Anyone got any ideas?