Chart Category X-Axis

[Bobadopolis]

Hi,

I have a series of bound charts in a report. My X-Axis data is numeric and sometimes different for each record but always falling in a specific range. Is there a way to make the X-Axis numeric (not categorical) so that when I plot the data the values fall in appropriate places? A logarithmic scale would also be ideal but not essential.

Thanks,

Bobadopolis

 

[Bobadopolis]

Got it!

Firstly, the Access Chart Wizard is rubbish!!

My mistake was that I was using a line chart instead of an XY scatter. For some reason though instead of changing the chart from line to XY scatter I tried to insert a new one! The wizard was completely rubbish for this until someone suggested changing the chart type of my current chart! This worked a treat and I even have the option to have a logarithmic scale!

So, lessons to be learnt from this tale:

If you're creating charts for comparing control data (that may change) with several series of data try creating a line chart (or similar) first so that the series data is how you want it.

Once you are (relatively) satisfied change the chart type to XY scatter and choose appropriate lines.

Hope that helps someone in the future

Bobadopolis