A bar chart showing percentages?

[Guest]

Hello,

I've stuggled for ages to try and get a bar chart to show percentages but no
luck - can anyone help?

E.g. for a simple numeric 'number of children' field, I'd love to be able to
get:

0 |||||||||| 50%
1 |||| 20%
2 ||||| 30% etc.

....as a pie chart just isn't clear enough. Can I do this (in any way!) but
without modifing my table?

Any help very very much appreciated!!!
thanks, nicola

 

[Duane Hookom]

You can resize a text box or other control using code in the On Format event
like:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.txtBar.Width = Me.Quantity * 360
End Sub