Graph chart with reference line

[matteocarnelos]

Hi guys,

I'm new in this forum and I hope to have posted in the right section.

So, in my situation I've 12 values of lead time of 10 articles (one value for month for each article), and for each article I've an ideal lead time (see next image).

DataBase

I would to create a line chart to monitor the trend: putting in the x axis the months, the values are the lead time, in the legend there are the articles (so, a line for each article), and I would also to show the horizontal line with the ideal lead time for each article.

I know that in other software there is the possibility to do this, but the ideal lead time is only shown selecting each article, also this can be a solution in my situation.

I try to explain better with the follow images.

Have you some idea to create this?

Thank you,

Matteo

[v-jiascu-msft]

Hi @matteocarnelos,

Seems the Analytics line could help.

Best Regards,

Dale

[matteocarnelos]

Hi,

thanks for the reply, but this solution isn't work in my situation: because I can't insert a value by keyboard, but I've to insert the values that are in a column in another table in the database, and these values are different for each element.