formatting a cluster column chart (1 Viewer)

[109bow]

Good afternoon,
I have a cluster column chart in a form that is displaying values below what I would call the x-axis, see photo chart1. This chat is based on a table, see table1 and 2.
I wish to not display these values, but so far have not been able to find out to remove them.
As a novice I've probably done something fundamentally wrong, so any advice much appreciated.

 

[mike60smart]

Hi
In design view of the Form, if you Right Click on the Chart and select Properties you can remove the various Elements.

See attached screenshot

 

[109bow]

mike60smart, thanks for the reply. After trying the options in the property sheet I still have not been able to remove the 0s and 1s from the chart.
Its weird as I've created cluster bar charts before but had this issue.
Any other suggestions would be welcome.

 

[mike60smart]

mike60smart, thanks for the reply. After trying the options in the property sheet I still have not been able to remove the 0s and 1s from the chart.
Its weird as I've created cluster bar charts before but had this issue.
Any other suggestions would be welcome.

Can you upload a zipped copy of the database?

 

[109bow]

unfortunately the zipped file is too large to attach

 

[isladogs]

Your first screenshot clearly shows both the problem & the cause.

You need to edit the Data tab of the Chart Settings Task Pane
Click the chart and the Task Pane opens
On the Data tab, untick all unwanted items from the Axis (Category) section
You may need to check one of the first two items instead e.g, car type