I want to create a chart with two different scalings (steps of 500 and steps of 10.000) on the y-axis.
This is needed because there is a fixed cost of 1000 (so a straight line from left to right) and three graphs for different scenarios, which all have rather high values in the end.
Currently this leads to the fixed cost line being extremely small and barely visible, because I have to choose a rather big scale (10.000) in order to get a reasonably sized chart.
However, I want this fixed cost line and especially the points of contact clearly visible.
Imho, to achieve that I need to use two different scales. I came up with a quick and dirty sketch of my desired result in MS Paint:
Is it possible to achieve this with Excel? Appreciate any tips