Hi Miguel,

Welcome to our forum. The file didn't get attached. You need to click 'start upload' after selecting your file, then wait for the grey check mark beside the file size before clicking 'submit reply'.

Mynda

File Attchament

Hi Miguel,

Thanks for sharing the file.

You need two or more points to draw a line. If you look at series 1, you can see it references cells AC16:AC82 (note, it should be AC10:AC82 because the line is displaying on the chart out of alignment with the axis labels). The label for that series is based on cells AD16:AD82 (and should be AD10:AD82).

You need to replicate that series for the remaining 7 series so you end up with 16 series in the chart 8 for the lines and 8 for the labels.

The technique is explained in detail in this post: dynamically label Excel chart series lines.

Mynda

Hi Mynda,

Thanks for your quickly reply. Anyway I write on your youtube video the problem. 

Someone help me with this problem but didn't work so fine. That person create for serie 1 and for the label (AC3 to AD8). And if I select the "serie 1 Mes" say is read AD3 and AD7. Is only work if I select from AC16 and not AC10, if not the label don't go for the right position. The problem is I can't understand how is possible create just a serie with 1 variable (X) - for the values,  and how to create a serie with 2 variables (X and Y) to the label.

The last problem is from AC53 to the end I have a formula that return the value of another cell or if is without value return N/D. In your video you have in your example from AC53 to the end cells empty (without formula).

Thanks again for your time and help,

regards

Miguel 

Hi Miguel,

Change the chart type to 'Line chart with markers'. Not scatter and not stacked line chart.

Then add/edit all of the series to point them at the data in rows 10 to 82.

You also need to add series for the data labels.

It may be quicker to rebuild the chart from scratch following the steps in my video.

Note: you will also need to change the formula in the label columns e.g. AD10:AD82 should be:

 =IF(ISERROR(AC10),AC10,IF(ROW()=LOOKUP(2,1/(NOT(ISERROR($AC$10:$AC$82))),ROW($AC$10:$AC$82)),AC10,NA()))

In the attached file I've done the first two for you. I hope that points you in the right direction.

Mynda

Hi Mynda,

Thank you very much for your help. I'm almost there !!

I just don't understand 1 thing:

You have "Serie 1" subtitle entry from AC10:AC82 and axle labels (date from AA10 to AB82);

You have "Serie 1 Mes" subtitle entry from AD10:AD82 and axle labels (cell AD3);

when I add the Serie 3 as you make Serie 1 and 2, and try to change the subtitle entry or the axle labels it change all the values in serie 1 and 2.

Don't understand what I'm doing wrong !!

Thanks again for your help.

regards,

Miguel

Hi Miguel,

Each series is effectively 2 series, one for the line and one for the labels. If you open the Select Data Source dialog box (right-click chart), the series for the labels is 3 MES and the series for the line is 3 (listed at the bottom of the legend series).

When I edit 3 MES and change the Series Values range to AN10:AN82, the chart updates correctly. Then I simply select that series from the Format tab > Current Selection drop down on the far left, and add data labels to it.

Mynda