I’m having a bit of trouble and hoping that you’d be able to help. I’m trying to create a graph which will show a forecast range (there’s a picture at the bottom with an example), but can’t seem to get this right. Below is a picture of the current graph.
I’m trying to do the following:
Reduce the number of labels on the x-axis, I’ve tried like crazy to do this. Am I missing something perhaps? The graph is dynamic and based upon the user’s input, so I can’t make this a static value.
I’m trying to change the shaded area so that you can only see the light orange part at the top. Essentially, I want to show the area between the Upper Forecast and the Lower Forecast, with the 70% Forecast being a straight line. I have tried to change the order of the series (currently the Upper Forecast is Series 1), but then when you hover over a data point, it shows the Lower Forecast at the top of the tooltip, which looks very wierd.
Lastly, is there a way to change the Y-axis prefix? I’m from South Africa and our currency is Rands (or “R” for short).
Here is an example of the type of graph that I’m trying to create:
Thanks for the help!