Line Graph - unable to split lines up to show separate data

**chris.smith93** · 06-04-2021, 06:33 AM

Good morning,

As per my uploaded image, i need to be able to show a separate line on the graph for each of the following
- 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 show 'CoWD' and 'CoWD Previous Month' into an additional two lines in order to separate into 'Current' and 'AIW element'. The data used for the graph is shown above the chart in the photo attached.

Thanks in advance

Chris

**KOKOSEK** · 06-04-2021, 07:05 AM

Cross-post here: https://www.mrexcel.com/board/thread...ormat.1172859/

**chris.smith93** · 06-04-2021, 07:13 AM

Is it okay to post on both pages or do I need to state this in future?

Thanks
Chris

**KOKOSEK** · 06-04-2021, 07:19 AM

Check Forum rule #3

**chris.smith93** · 06-04-2021, 07:41 AM

My apologies, and thanks for the heads up!

**Andy Pope** · 06-05-2021, 04:38 AM

You need to restructure your data in order to make the chart understand how you want your data treated.

With the original layout you still need to stagger the data adding extra rows. In order to remove the blank columns I filtered them out.
The Connect points option is applied, via the Select Data > Hidden Cells option.

Underneath is a more compact way of laying out the chart data.

Either layout will require you to adjust the vertical axis in order to maximise the distance between very similar data values.