How To Add A Horizontal Line In Sigmaplot

Sometimes yous demand to add a horizontal line to your chart. E.g., this will be useful to show data with some goal line or limits:

To add a horizontal line to your nautical chart, do the following:

   i. Add the cell or cells with the goal or limit (limits) to your data, for example:

   ii. Add a new data series to your chart past doing one of the post-obit:

• Nether Nautical chart Tools, on the Design tab, in the Data group, cull Select Information:

  

• Right-click in the chart area and choose Select Information... in the popup carte du jour:

  

In the Select Data Source dialog box, click the Add together button and in the Edit Series dialog box, blazon:

• In the Series name box - the proper noun of this line ( Goal ),
• In the Serial values box - the prison cell with the goal ( $C$17 ):

   iii. If it is necessary, change data series:

   iii.1. Correct-click in the new data series and choose Modify Serial Nautical chart Type... in the popup carte du jour:

   3.2. In the Modify Chart Blazon dialog box, cull the Scatter type:

   iii.3. Repeat step ii to change the data series:

In the Select Information Source dialog box, select the added data series and click the Edit push button, then in the Edit Serial dialog box:

• In the Series X values box - add whatever jail cell from the horizontal (category) axis (for case, $A$8 ):

You will see the right data for the same horizontal (category) axis:

   iv. Under Chart Tools, on the Design tab, in the Nautical chart Layouts group, click the Add Chart Element icon and choose the Error Confined list:

Excel proposes several error bars; also, you tin apply More than Error Confined Options.... If necessary, you lot tin can fine-tune the fault bar settings from the Format Error Bars pane:

To specify the length of the error line, click on the Specify Value button, and blazon the advisable value for negative and positive values. For this example:

You can then make any other adjustments to get the expected look.

See besides this tip in French: Comment ajouter une ligne horizontale au graphique.

How To Add A Horizontal Line In Sigmaplot,

Source: https://www.officetooltips.com/excel_2016/tips/how_to_add_a_horizontal_line_to_the_chart.html

Posted by: rosadotorty1998.blogspot.com

Share this post