line chart for FC vs. AC

[sanlen]

Hi,

I have the data as in the attachment. I am trying to make a line chart to compare the progress of Focus (FC) vs. Actual (AC). However, i cannot make it this out. Seem i always get only one line.

Could you please advice? Your comments will be very much appreciated.

[StephenR]

Does your data have to be arranged that way? It would be easier if you could arrange like so:

w6 w7 w8 w9
fc 13 17 25 34
ac 23 30 32 48

It can be done as is, but you have to identify both series manually.

[sanlen]

Hi,

Yes, i can go the way you have suggested, the problem is i have to re-arrange the whole sheet .

[StephenR]

Sanlen - although it will be a bit of work up-front, I think most people here will tell you that it will save time in the future.

[sanlen]

Hi,

Thanks you very much for your advice. I am taking your guidance now