Bar Chart Problem

[cpitc]

I have a cross tab report that uses a maximum to calculate a fixed planned budget figures. When the colum is added into a Graph the colum just goes to the highes amount and not the real amount.

For example January figure is 227,000.00 but on the graph the bar fills the entire column (axes starts at 0 and goes up to 600,000) so it goes up to 600,000. Any ideas how I can make the colum just go to the 227,000 mark and not the whole column.

Thanks

 

[cpitc]

Its ok got this one sorted, I changed the Sum to maximum in the chart expert.