Hello!
I am trying to make a chart look like this:
I have a data set that has goals and I want the series to be the goal milestones and the filled in line to be an operators total sales. I am unsure if there is a chart that can do this or I have a workaround because there are very many goals.
My data set looks like this:
I have the milestone amount as goal number 1 and then the amount it will take to get to the next milestone, which for goal number 2 is actually 5,000,000, but will take 1,000,000 more to hit it . Should restructure my data?