If you are still having trouble with this, please describe your table, sort and data type of the sort field(s) in much more detail. Also, what data source option did you specify? (one option will create a single bar for a group of records with the same value in the sort field...)
Hello Phil, thanks for your reply.I managed to get it working. it was setting inside the chart setup.
For others who may have same issue , ill attached the snapshot here.