Hello, this might be a complex scenario , but here's what I am trying to do:
I have 3 metrics on a time scale.
Let's say it is Sales, Profit and Number of salespeople
What I want is
(1) an area graph of sales and profit on the same scale (using the left axis) and
(2) a line graph for the number of salespeople on a different scale (using the right axes)
I can create all 3 of them, but can only overlay 2 of them together and not 3
How can I potentially overlay 3 in one graph?
Is this what you are looking for? I have used the Superstore Data to replicate your scenario. Check out the attached workbook.
In your case, you probably need to drag the bottom measure and drop it on the left axis.
Hope this helps.