I'm making a diagram of a (financial instrument) portfolio value change (%) over time. I would like to add information to the chart about the total value of the portfolio at any given time. My idea was to add data labels "values from cells" linked to the total value of the portfolio. The problem is that all the data labels are called out, leaving me with an extremely cluttered diagram. What I would like to achieve is that when I hover the mouse over the diagram it would at any point give:
- Date
- Value change x% (which is what's being graphed)
- Total value (USD)
Is there a way to hide data labels while also addding labels from cells?
Bookmarks