Tried to make a chart, column type, with two scales on the left side and one scale on the right. But can't get farther than the basic samples in Excel.

The smaller scale on the left is from approx. 8 to 25, the bigger one from approx. 500-1200. The scale on the right from approx. 200,000 to 1,200,000.
At the bottom are the years 2007 to 2012.
The data is read from A1-F5.

A1 = 2007............ F1 = 2012
A2 = 313,000........F2 = 1,083,000
A3 = 360,000........F3 = 1,040,000
A4 = 11.8............. F4 = 19.0
A5 = 510.............. F5 = 969

with similar data in the B to E columns.
The data in Rows 2-5 (A, B, C, D) have 4 different colors. Can these colors be changed?