Thank you for your Reply Katia;
I've attached 3 images describing the problem I'm having with my Chart.
My data has 2 columns: 'Year' and 'Amount'
I need a column chart that shows each 'Year' in a Column with a different color.
The nicest looking chart I got was when I assign the Chart categories to 'Year' and Chart values to 'Amount', but this makes all the columns of the same color (see attached image g1.png).
When I assigned the Chart series to 'Year' and Chart values to 'Amount', I got all the columns to be attached to each other, and the x-axis title to be 'All' instead of each column having it's own title (see attached image g2.png).
Last, I've assigned the Chart categories and Chart series to be 'Year' and the Chart value to be 'Amount'.
the result was a thin, left aligned columns (see attached image g3.png).
I'm best looking one is my first attempt, so I thought I can solve the column colors issue by accessing the graph data points and override the assigned colors