Wanting to have a block chart but all the blocks are the same colour, how can i get it to show different colours automatically without having to alter each and everyone of them manually?
I was able to do this with a piechart but the pie chart is not needed as it is not easy to read with my figures so wanting to use a block chart instead.
i am using Excel 2002
Bookmarks