Steema Central

Hi there everyone,

Probably doing something really stupid (hopefully...) but I have a database table which I am trying to display in a Bar Chart. Data similar to as follows:

PUPILID PUPILNAME VALUE
1 Ben 15
2 Rob 17
3 Geoff 12
4 Wendy 16
5 Jenny 15

The idea is that VALUE would appear on the Y Axis, and each Bar within the Chart would represent a Pupil. With this in mind, I want the X Axis to say, underneath each Bar, the corresponding Pupil Name. However, whenever I set the XValue.ValueSource to PUPILNAME, it would error with (for example) "'BEN' is not a valid floating point value".

What do I have to turn off or change so the X Axis does not expect a floating point value? Or in order to display this field do I need to do something else entirely?

Thanks in advance.
Ben

Hi Ben,

You could set the PUPILNAME to be used as the series Labels, LabelsSource, instead of XValues.ValueSource.
There is an example of how to do something like this in the "Tutorial 8 - ADO Database access".

Perfect!
Thanks for your quick response.

Kind regards,
Ben