Need help in creating line charts from a data set

Hey Oliver,

Thanks for the reply i really appreciate it and it has helped a lot. Finally very very close to complete my task will be able to focus on the write up part now.

Thanks a ton.

Regards,

Aditya

Hi Aditya,

please have a look to "Sheet1". I added some notes in Col K. To solve this problem I used the formula TEXT.

Please let me know if this works for you.

Best, Oliver

Hey oliver,

Thanks for the suggestion i found the way to do that for the days that was much easy but now i need that to be done for the week and other filters which i need but the problem is that there i have to give some range which i have mentioned in the below attached file.

The problem is that by using this formula the range cannot be displayed and hence having some issues regarding that final output of the chart.

This is the final output for my file which i have to do the rest all has been resolved done it the analysis part also has been completed but just this final graphical presentation needs to be worked on now.

Attaching the file below.

Regards,

Aditya

Hi Aditya,

click on the titel of the chart and connect it to any cell as shown in the following picture:

Step1: click on the titel

Step2: type an equal sign

Step3: click on any cell

Result: the titel is connected to the selected cell. within this cell you can creat dynamic titels.

In the attached file you can see in cell H6 and H7 how a dynamic titel could look like.

Best, Oliver