CODEWITHSUNDEEP
excelplot
Aman
Aman

Reputation: 1197

Different groups with single line, plotting in Excel

My problem:

I have a column of data and a column of condition (3 conditions). My goal is to plot my data based on iteration (iteration would be my x axis), and colour different portions of the plot based on the condition. Unfortunately, I have to use excel.

What I did:

I subdivided my column to 3 different columns based on condition

Then, I plotted them all together (scatter plot). So far everything is OK, but for the sake of presentation, I need to connect all of these points with a single line (the plotting option gives me three lines).

Any help would be appreciated ( I prefer a non VBA solution for the time being as I have to present them tomorrow and I didn't use Basic for years)?

Example:

Condition---OG-------G2-------G3-------G4

0-----------95.6-----95.6-----#N/A-----#N/A

1-----------95.6-----#N/A-----95.6-----#N/A

3.2---------95.6-----#N/A-----#N/A-----95.6

Blue: G2; Red: G3; Yellow G4

I want to connect a line between these 3 points (with different colour based on the condition column): What I need

Upvotes: 0

Views: 175

Answers (1)

pnuts
pnuts

Reputation: 59485

In Excel 2013 (may be slightly different for other versions), merely select the data point to be joined up (here yellow, red would be necessary also) and select Solid line as shown:

SO25371216 example

Upvotes: 1

Related Questions