Adding a code for the legend in the chart at the bottom

Hello Friends,

Kindly find the attached file ( Excel and image) for your reference.

Everything is working properly, after two days of hard work ( by two of our guest).

But, now can somebody please help me editing the code, since I am not getting the name of the legend in the chart.

Let me explain you in short how everything works :

G-drift is the main page. After clicking on the create chart sheet - button, the new worksheets are generated , in those new WS, charts are created from the range in
Worksheet - "Overview"

All is okay, but the name of the legend is not visible (Refer image).

Thanks in advance

Regards,
Cadcraft

Hallo Joseph,

Your code is also working the same without label to Legends.

And if i delete the 3rd row in "Overview", then there are no charts.

Any other options ?

Regards,
Cadcraft

Hallo Joseph,

I just also tried, in the file which i send you. It is not giving any output (chart) at my end.

And also I can not delete the 3rd row, since in g-drift there are formulae related to it.

other way - we can avoid or hide 3rd row, but the legend is important.

regards,
Cadcraft

Hi Joseph,

I tried, but not working buddy.

I will again give a try after some time, but if it works also, I can not use it, as I told you that I have used
formulas from 4th row of Overview in G-drift.(In the table).

Regards,
Cadcraft.

Hello Andy,

It is working. But then look at the range on Y-axis, they repeat 0,00 0.00 0.01 0.01 0.01 in such a manner.

regards,
cadcraft

Hello Andy,

Yes it is working perfectly.

but now the thickness of the graph is too thick.

I would like to have a thinner line showing the values, rest all is ok.

Regards,
Cadcraft

Hello Andy,

With the above code it is still working the same way.

How do i change the line weight property, in code or manually ??

I am really not good in excel, thanks for co-operation.

Regards,
Cadcraft

Hello Andy,

Its changes to a mild difference, but not the exact thin line.

Thanks.

Regards,
Cadcraft.

Hallo,


I would really like to thank to all those who took out their time and helped me.

Here, following is the final code which works perfect, and hence, would like to end this thread here.

Again thanks to all.
Solved!

Regards,
Cadcraft

Please Login or Register  to view this content.