|
Insert and Format Trendline (single and multible) |
Status: Preliminary |
- |
|
- File / New / Spreadsheet
- Create cell range A2:D5 with random values
- Insert Chart Type XY (Scatter) Points and Lines using Toolbar
- Select a Data Series
- Kontextmenu / Insert Trend Line.../ Tabpage Type
- Choose Regression Type Linear
- Leave the Dialog by using ok
- Check, if the Trend Line for the selected Data Serie are available
- Select the Trend Line
- Format / Object properties... / Tabpage Type
- Change the Regression Type to Logarithmic
- Leave the Dialog by using ok
- Check, if the Trend Line for the selected Data Serie are switched to Logarithmic
- Format / Object properties... / Tabpage Line
- Change the Linestyle to Fine dashed
- Change the Line Color and the width
- Leave the Dialog by using ok
- File / Save as... {name of your choice}
- File / reload
- Chart inplacemode
- Check, if if the Trendline is visible and all changed Linestyles are adopted
- Insert / TrendLInes...
- Choose Regression Type Exponential
- Leave the Dialog by using ok
- Check, if the Trend Lines for all Data Serie are switched to Exponential
- Check, if the Trend Line for the former selected Data Serie are all Linestyles maintained
- File / Save
- File / reload
- Check, if if the Trendlines are visible and the changed Linestyles are adopted
|
|
Insert and Format Mean Value Line (single and multible) |
Status: Preliminary |
- |
|
- File / New / Spreadsheet
- Create cell range A2:E5 with random values
- Insert Chart Type XY (Scatter) Points and Lines using Toolbar
- Select a Data Series
- Kontextmenu / Insert Mean Value Line
- Check, if the Mean Value Line for the selected Data Serie are visible and available
- Select the Mean Value Line
- Format / Object properties... / Tabpage Line
- Change the Linestyle to 3 dashes 3 dots
- Change the Line Color and the width
- Set the Tranparency to 60 %
- Leave the Dialog by using ok
- File / Save as... {name of your choice}
- File / reload
- Chart inplacemode
- Check, if if the Mean Value Line is visible and all changed Linestyles and Transparency are adopted
- Insert / Mean Value Lines
- Check, if for each Data Series a own Mean Value Lines are set
- Check, if the Mean Value Line for the former selected Data Serie are all Linestyles maintained
- File / Save
- File / reload
- Check, if if all Mean Value Lines are visible and the changed Linestyles are adopted
|