Bar Charts & X Axis

[JobyLeigh]

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

[Yeray]

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".

[JobyLeigh]

Perfect!
Thanks for your quick response.

Kind regards,
Ben