Statistical confidence plot in Excel

[volabos]

Hi,

Let say I have below data -



Date
Lower bound
Mid
Upper bound
Point 1
Point 2


26/05/21
1
3
5
6
3.7


27/05/21
2
4
6
2.5
0.2


28/05/21
3
5
7
3
0.7


29/05/21
4
6
8




30/05/21
5
7
9
4
1.7


31/05/21
6
8
10
7
4.7



Now I want to plot statistical confidence plot something like this plot https://bit.ly/3fjK3Te

So in my plot, first 3 columns will be used to create such plot. However the remaining columns viz. Point 1 and Point 2 will be just points on the same graph corresponding to the relevant date.

I also want that, in the legend field, the names for Lower bound and Upper bound would not appear, instead something like "range area" to be displayed.

I have tried to create such plot in the attached excel file. Basically, I converted the columns for upper and lower bounds as Area, however could not succeed to create the exact plot as in the link.

Could you please help me to create such plot?

Any pointer will be highly appreciated.

Thanks for your time.28540

[Paul_Hossler]

Don't see how the linked screen shot applies, but something like this maybe

Don't know of anyway to do the legend


28542

ALl I did was plot the 5 columns, select Point1 and Point2 series, and format with No Lines