Line Graph - data not in usual format

[chrissmith93]

Good morning,

This doesn't feel like it should be difficult but, as per my uploaded image, i need to be able to show a seperate line on the graph for each of the follow
- Current CoWD Month
- AIW Element CoWD Month
- Current CoWD Previous Month
- AIW Element CoWD Previous Month

However, as you can see, i'm unable to separate the two lines that currently how CoWD and CoWD Previous Month into an additional two in order to separate into Current and AIW element.

Thanks in advance

Chris

 

[GraH]

Hi,

Hang on? Why would you plot 2 lines (current and previous month) on a line chart using a date Axis. Isn't this just 1 series over time? I'm a bit confused on what you try to achieve.
CoWD, AIW...? Jargon is a b***h, right.

Also, please use XL2BB to post sample data. If someone knows a solution, you force them to manually type in data to match you example. You understand that ain't picture perfect. Nobody likes to do tedious work.