volabos
05-25-2021, 01:25 PM
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
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