I have an excel that has several hundred points for maximum, average, and minimum calculations using datalink to pull data from Pi Process book. The Y-axes are the max,min, and average and my batch numbers are my X-axis.  In an attempt to make box plots with these three points, I have been unable to find an easy way to make each individual trend have the same formatting (line color, marker type, marker color, and even size). Is there an easy way to do this for several thousand trends on a single excel tab?

Thanks in advance.

I was trying to post an image but a message popped up saying "Body text cannot contain images or links until we are able to verify your accoutn".

Hi K.Eguiluz,

Please tell me which result did you want to get as shown in the following figure? Sign1 or Sign2?

I created these charts by using PivotChart in excel, you can try this method.

If my understanding is incorrect, you can send your image to our email address:
ibsofc@microsoft.com
Please Note: Please add the URL of the case in the email subject or body.

I'm glad to help and follow up your reply.

Regards,

Emi Zhang
TechNet Community Su