Hi, Community!
I have my first question, hopefully we can sort it out together.
I have my daily sales and I have a calculation with the average value of sales in the last 30 days. I want to visualise these two, as a line chart shown as area.
Everything looks fine, until I want to show the Value Labels for the Sales line. I can’t find an option to show the Labels only for the Sales and keep the Average just as a line. It keeps showing on every point and looks awful.
Adding a Reference Line does not work either, as I need the area below the Average to be coloured (say, in blue) while the area of Sales to be yellow, so we see in this way when we are ‘under’ or ‘over the surface’.
Hope that makes sense as an explanation of my issue. Thanks for your time & help!