I’ve been trying to create a chart based on the below information. So far what I’ve been getting is, my chart is not at all CLUSTERED .For instance on the X-axis the months Aug’04 & Aug ’05 are at the opposite ends of EACH OTHER. Basically I want them to be side by side. And the Colour REPRESENTING EACH YEAR ( i.e 2004) should be the main differentiator between the months
year 2004 2005
Apr '05 R 178,1
Aug '04 R 117,
Aug '05 R 191,1
Dec '04 R 311,9
Feb '05 R 174,1
Jan '05 R 994,0
Jul '04 R 120,1
Jul '05 R 164,5
Jun '05 R 163,2
Mar '05 R 167,6
May '05 R 155,0
Nov '04 R 266,7
Oct '04 R 98,06
Sep '04 R 118,8
Sep '05 R 158,6
year 2004 2005
Apr '05 R 178,1
Aug '04 R 117,
Aug '05 R 191,1
Dec '04 R 311,9
Feb '05 R 174,1
Jan '05 R 994,0
Jul '04 R 120,1
Jul '05 R 164,5
Jun '05 R 163,2
Mar '05 R 167,6
May '05 R 155,0
Nov '04 R 266,7
Oct '04 R 98,06
Sep '04 R 118,8
Sep '05 R 158,6