Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Below are two images of graphs that will help illustrate my question better:
What I'm doing here is comparing product penetration rates in a year-over-year fashion (for fiscal years 2018-20). The lines in the first graph are penetration rate percentages for a particular product. The lines in the second graph are the number of companies who own the product. My company's fiscal year begins in July.
As you can see, in the first graph, my 'FY20' line stops in March, as obviously we haven't reached April, May, or June yet in 2020. In the second graph, my 'FY20' line doesn't stop in March, it drops to 0 in April and carries through June. I want the second graph to look like the first graph, where the 'FY20' line stops in March (and there is no drop to 0 onwards).
What confuses me is I have compared the two graphs side-by-side, and all of the specifications of the graphs within Data, Sorting, Add-ons, and Appearance are exactly alike (besides the different calculation in Data obviously).
Let me know if anything jumps out to you guys, or if I can provide any additional info that would be helpful like the codes I'm using for my calculations. Thanks a bunch!
