I need to design a graph/chart with 2 lines. One line is the average of the weight of the delivered goods for each calendar week of the year, for all customers. The second line shows the average weight for each delivery of only one customer. So this customer can see how his weight of the delivery is in realation to the average weight of deliveries of all customers.
The requirement is that the first line (average weight for all customers) should be a normal line, and the second line (the customer deliveries) should be points (not a line) on the graph. The problem I have is that I can only chose the line type pro Graph/Chart and not pro ploted value.
Is there a workaround, or a setting to achieve this requirement?
Any ideea would help me a lot!