Axis not displaying correctly on chart

Question

I am trying to make a control chart that uses 3 area graphs (split by layers). Each layer indicates 1std dev, 2 std dev, and 3 std dev. Then I am graphing a bar chart to see where the data lies. The axis are not displaying correctly for the area graphs and I'm not sure why.

control charts.yxmd

data.xlsx

Qiu · Answer

@elliehanson96

If below is what you need. I think 2 points are missing

1. Before entering Chart tool, Data needs to be sorted

2. Since there are multiple entries for one day, Sum to be applied for each layer.

control charts.yxmd

TrevorS · Answer

Hello @elliehanson96

Do you have an example of how you would prefer this data to look in its final form?

Additionally, are you trying to make adjustments to the Defect Rate Data?
Thanks!
TrevorS