How to Plot graph with Multiple Data Sets in Microsoft Excel (scatter function)

Hi,

If you have more than one data sets to be plotted on the graph, you can easily do that in excel under the 'insert'  scatter option. Follow the given eight steps with images. 

Step.1 Make three data sets separately, and choose 'scatter' graph under 'insert' menu.

Step.2 Right click on the scatter graph, and select 'select data'

Step.3 Click on add and a small box will pop up. Give any series name, say 'Data Set 1', select all cells containing x -axis and y-axis values for the corresponding given boxes.Once you click 'ok' those blue data dots will appear on the scatter. 

Step. 4 Now again click 'add' in the select data option, and then give another series name, say 'data set 2' and choose the corresponding data from data set 2 on the cells. Once done, those maroon colored dots will appear corresponding to 2nd data set.

Step. 5 Repeat step.4 for data set 3, and those light green dots will appear.

your 'select' data box will have now three series of data, and you can edit them or remove them, or you can even add another data set, by clicking on 'add'

Step.7 You can add trendlines to make it more appealing.

click on the series for which you want to add trendlines, once dots get selected, give a righ click, and this add trendline option will appear.

select among various options, how you want it to appear, linear, polynomial, etc. are various options, here I am selecting 'moving average.'

If you do same for all three series, this is how the final graph look like.

Thank you for vising!

Take care!

Use Method of Section on Gambrel Truss and Find section Forces - Solved Example

Hi,

Problem:
This is a Gambrel Truss with 5 known load forces on it as shown below. Let's say the reaction forces are already found, at A(0, 959.6 N) and at H(0, 450 N). Each applied load is 300 N.

Use the method of sections to determine all the unknown external forces acting on section ABG. Using your results, list whether members BD, BE, and EG are in compression or tension?



Solution:



Thank you for your kind visit.

High Point of a Vertical Crest Curve - Solved Example

Hi,

Problem:
A 1200 ft crest vertical curve is defined by grades of +2.0 percent and -4.0 percent, respectively. If the elevation and station of the PVC is 200 ft and 202 + 30 respectively. determine the elevation and station of the highest point on the curve.

Solution:


Thank you for your kind visit. If you have any doubt, please let me know in the comment box.

Increase in flow when Two parallel Identical Rectangular channels are combined to form Single with same Depth

Hi,

Problem: Two parallel identical rectangular channels have a base width B= 3ft and are flowing with a depth D= 2ft. Calculate the percentage increase in flow rate if the channels were combined into a single rectangular channel of bse width 2*B = 6 ft and the same channel depth. 



Solution:


If the example was helpful to you, please let me know. If there is any doubt, please ask in the comment box.

Thank you!

Statics - Forces in three cables supporting a weight - (Solved Example)

Hi,

Problem:
Determine the force in CA, CB and in CD cable needed to support the 480-lb load. Give results with minimum 2 significant figures. 




Solution:



Thank you for the kind visit!

Moment of Three Vector forces about a Point O and its Resultant (solved example)

Hi,

Problem: 

Determine the resultant moment about the fixed end at joint O.

F1 = (-60i + 40j +20k) lbs

F2 = (80i + 40j -30k) lbs

F3 = (40i + 20j - 15k) lbs

A) Show all steps using Cartesian Vector Notation.

B) Show all steps using Scalar Notation.

C) Show the final orientation of the MO on a sketch.

Solution:

If you have any doubt, please leave a comment below.

Thanks!

Extension of Tapered Bar (Cone Frustum) due to its Self weight and applied Load (Solved Example)

Hi,

Problem: A uniformly tapered bar of steel 500m long is suspended vertically and supports a land of 1KN attached to the lower end. The bar has a circular cross-section with a diameter of 10 mm at the lower end and 20 mm at the upper end.
Find the total extension of the bar due to its own weight and the suspended load. Take the specific weight of steel as
80 kN/m3 and E=210 GPa.

Solution:

If you find any doubt or any problem with the solution, please leave a comment or suggestion.

Thank you!