hasconnect.blogg.se

How to make a rose diagram in excel
How to make a rose diagram in excel








how to make a rose diagram in excel

Cold-to-hot: This option will fill the petals with different colors.

how to make a rose diagram in excel

  • Monochromatic: This option will fill the petals with a single color which you specify.
  • CHECK this box to fill the petals with color.
  • Leave this box UNCHECKED for no petal fill.
  • Perimeter Thickness: Select the line thicknessin pixels.
  • Perimeter Color: Select the petal outline color.
  • This will determine the size of the class interval grouping of measurements.
  • Width: Use this setting to establish the petal width in real number degrees.
  • To the right there is a variety of petal options.
  • Petals: To turn on the plotting of the rose petals, insert a check in the Petals check-box.
  • Expand this item to set the label color and size, offset from the ray, and spacing (in real number degrees).
  • Labels: If you have activated the plotting of reference rays, you may include labels on them by inserting a check in this check-box.
  • ! You may want to make the ray spacing equal to, or an even multiple of, the petal spacing, below. To the right you can set the color and ray spacing in real number degrees.
  • Rays: Check this box to include reference rays, which extend from the center of the rose outward.
  • This can be helpful if the ring label and the azimuth labels overplot.
  • Omit Outermost Ring Label: Insert a check here if the outer ring's label is to be omitted.
  • Labels: Insert a check in this box to include labels on the circles.
  • Spacing: Enter the intervals for the circles, being mindful of the Diameter setting you've selected at the bottom of the window.
  • Or, CHECK this box to manually define the circle intervals.
  • Leave this box UNCHECKED if you want the program to determine automatically the appropriate spacing of the reference circles/arcs based on the range of petal lengths.
  • Color: Choose the color in which the circles will be drawn.
  • how to make a rose diagram in excel

    To the right you can define the circle settings: Circles: To include concentric reference circles (full rose diagrams) or arcs (half rose diagrams) that signify percent or occurrences or total lengths (depending on the source data), insert a check in the Circles check-box.If the data is uni-directional, be sure that this box is cleared. Bi-directional: To specify that your data be considered bi-directional in nature, insert a check in the Bi-directional check-box.To the right, enter the amount in degrees clockwise from North (0 to 360) by which each lineation measurement should be rotated. Rotate: Insert a check in this box to turn on data rotation.As above, bearings must be entered in degrees (0 - 360) rather than quadrant. Minimum: Enter the minimum lineation or fracture bearing that is to be included in the processing.Azimuth Filter #2: Check this to activate a second bearing filter.If the data are bi-directional in nature, the program will also filter out the data that is 180 degrees opposite the filter specifications. The maximum azimuth must be designated in a clockwise manner from the minimum. Maximum: Enter the maximum acceptable lineation bearing.For this filter, bearings must be entered in degrees (0 - 360) rather than quadrant. Azimuth Filter #1: Check this to activate a bearing filter.Any lineations longer than this will be omitted from the diagram and computations. To the right, type in the maximum acceptable length in your map units. Maximum Length Filter: Check this box to activate an upper length filter.Any lineations shorter than this will be omitted from the diagram and computations. To the right, type in the minimum acceptable length, in your input units. Minimum Length Filter: Insert a check here to activate a lower length filter for the lineations.Length as a Percent of Total Lineation Lengths: This option sets the petal length to represent the percent of total lineation lengths that fall within this bin.










    How to make a rose diagram in excel