From 21c07ae6febccb6fab0d58c7d5bbf9628a06f4db Mon Sep 17 00:00:00 2001 From: Kurt Zenker Date: Fri, 11 Sep 2009 16:06:18 +0000 Subject: CWS-TOOLING: integrate CWS chartuseability01 2009-09-07 17:26:44 +0200 iha r275906 : CWS-TOOLING: rebase CWS chartuseability01 to trunk@275801 (milestone: DEV300:m57) 2009-08-27 13:48:16 +0200 iha r275481 : #7049# listbox to select chart elements 2009-08-27 11:54:53 +0200 iha r275464 : #i58163# #i69422# #i102820# enhance chart context menu 2009-08-26 16:49:58 +0200 iha r275435 : #i102820# added missing case 'floor' 2009-08-26 15:33:51 +0200 iha r275427 : #i102820# make 'insert legend' work properly 2009-08-25 16:35:00 +0200 ufi r275369 : i104087 2009-08-25 15:12:17 +0200 iha r275360 : #i104087# 'Object Properties' -> 'Format Selection' 2009-08-25 15:11:31 +0200 iha r275359 : #i104087# 'Object Properties' -> 'Format Selection' 2009-08-25 15:11:15 +0200 iha r275358 : #i104087# 'Object Properties' -> 'Format Selection' 2009-08-25 11:57:43 +0200 iha r275344 : #i104087# changed behavior of insert menu 2009-08-18 12:53:54 +0200 oc r275093 : #i104082,104086,104089# multiple changes because of changed chartUI 2009-08-10 16:46:17 +0200 ufi r274824 : i104083 i104087 i104090 2009-08-07 14:04:34 +0200 iha r274763 : #7049# listbox to select chart elements 2009-08-07 13:06:05 +0200 iha r274760 : #7049# listbox to select chart elements 2009-08-07 13:05:06 +0200 iha r274759 : #7049# listbox to select chart elements 2009-08-07 12:32:31 +0200 iha r274756 : #i58163# #i69422# #i102820# enhance chart context menu 2009-08-07 12:31:54 +0200 iha r274755 : #i58163# #i69422# #i102820# enhance chart context menu 2009-08-06 19:00:48 +0200 iha r274742 : #i103593# make insert menu behavior selection dependent 2009-08-06 19:00:14 +0200 iha r274741 : #i103593# make insert menu behavior selection dependent 2009-08-06 15:34:01 +0200 iha r274731 : #i58163# #i69422# #i102820# enhance chart context menu 2009-08-06 14:39:20 +0200 iha r274728 : #i86146# ease adding R-squared value with an equation 2009-08-06 14:37:02 +0200 iha r274727 : #i86146# ease adding R-squared value with an equation 2009-08-06 13:37:54 +0200 iha r274724 : #i86146# ease adding R-squared value with an equation 2009-08-06 13:37:15 +0200 iha r274723 : #i86146# ease adding R-squared value with an equation 2009-08-06 13:04:27 +0200 iha r274722 : #i103593# make insert menu behavior selection dependent 2009-08-06 13:03:35 +0200 iha r274721 : #i103593# make insert menu behavior selection dependent 2009-08-05 18:26:31 +0200 iha r274693 : #i104033# inconsistent wording 'error indicator' <-> 'error bar' 2009-08-05 16:51:45 +0200 iha r274688 : #i104028# rename font tabpage 'Characters'->'Font' 2009-08-05 16:30:21 +0200 iha r274685 : #i58163# #i69422# #i102820# enhance chart context menu 2009-08-05 15:34:11 +0200 iha r274680 : #i58163# #i69422# #i102820# enhance chart context menu 2009-08-05 15:32:43 +0200 iha r274679 : #i58163# #i69422# #i102820# enhance chart context menu 2009-08-05 15:31:26 +0200 iha r274678 : #i58163# #i69422# #i102820# enhance chart context menu 2009-08-05 15:17:51 +0200 iha r274676 : #i58163# #i69422# #i102820# enhance chart context menu 2009-08-05 15:16:22 +0200 iha r274675 : #i58163# #i69422# #i102820# enhance chart context menu 2009-08-05 14:58:59 +0200 iha r274674 : #7049# listbox to select chart elements 2009-08-05 14:33:54 +0200 iha r274669 : #7049# listbox to select chart elements 2009-08-05 14:22:17 +0200 iha r274665 : #7049# listbox to select chart elements 2009-08-05 13:21:05 +0200 iha r274656 : #i102820# offer insertion of several elements in context menu also if nothing is selected 2009-08-05 11:56:06 +0200 iha r274647 : #7049# listbox to select chart elements 2009-08-05 11:43:40 +0200 iha r274645 : #7049# listbox to select chart elements 2009-07-24 19:46:50 +0200 iha r274318 : #i58163# #i69422# #i102820# enhance chart context menu 2009-07-24 16:23:13 +0200 iha r274313 : #i58163# #i69422# #i102820# enhance chart context menu 2009-07-24 16:13:22 +0200 iha r274311 : #i58163# #i69422# #i102820# enhance chart context menu --- helpcontent2/source/text/schart/00/00000004.xhp | 16 +- helpcontent2/source/text/schart/01/04010000.xhp | 4 +- helpcontent2/source/text/schart/01/04020000.xhp | 4 +- helpcontent2/source/text/schart/01/04030000.xhp | 85 ++-- helpcontent2/source/text/schart/01/04040000.xhp | 4 +- helpcontent2/source/text/schart/01/04050000.xhp | 6 +- helpcontent2/source/text/schart/01/04050100.xhp | 35 +- helpcontent2/source/text/schart/01/04060000.xhp | 25 +- helpcontent2/source/text/schart/01/04070000.xhp | 4 +- helpcontent2/source/text/schart/01/05010000.xhp | 12 +- helpcontent2/source/text/schart/01/05010100.xhp | 2 +- helpcontent2/source/text/schart/01/05010200.xhp | 2 +- helpcontent2/source/text/schart/01/05020100.xhp | 60 ++- .../source/text/schart/01/three_d_view.xhp | 257 ++++++----- helpcontent2/source/text/schart/01/type_stock.xhp | 499 +++++++++++---------- helpcontent2/source/text/schart/main0000.xhp | 211 ++++++--- helpcontent2/source/text/schart/main0202.xhp | 67 +++ helpcontent2/source/text/schart/makefile.mk | 1 + helpcontent2/util/scalc/makefile.mk | 1 + helpcontent2/util/schart/makefile.mk | 1 + helpcontent2/util/sdraw/makefile.mk | 1 + helpcontent2/util/simpress/makefile.mk | 1 + helpcontent2/util/swriter/makefile.mk | 1 + 23 files changed, 740 insertions(+), 559 deletions(-) create mode 100755 helpcontent2/source/text/schart/main0202.xhp (limited to 'helpcontent2') diff --git a/helpcontent2/source/text/schart/00/00000004.xhp b/helpcontent2/source/text/schart/00/00000004.xhp index 9aa9ca658e..9a3f58ca6a 100644 --- a/helpcontent2/source/text/schart/00/00000004.xhp +++ b/helpcontent2/source/text/schart/00/00000004.xhp @@ -70,7 +70,7 @@
Choose Insert - Data Labels (Charts) -Choose Format - Object Properties - Data Point/Data Series - Data Labels tab (for data series and data point) (Charts) +Choose Format - Format Selection - Data Point/Data Series - Data Labels tab (for data series and data point) (Charts)
Choose Insert - Axes (Charts) @@ -107,25 +107,25 @@ Choose Insert - Special Character (Charts) -Choose Format - Object Properties (Charts) +Choose Format - Format Selection (Charts) -Choose Format - Object Properties - Data Point dialog (Charts) +Choose Format - Format Selection - Data Point dialog (Charts) -Choose Format - Object Properties - Data Series dialog (Charts) +Choose Format - Format Selection - Data Series dialog (Charts) -Choose Format - Object Properties - Data Series - Options tab (Charts) +Choose Format - Format Selection - Data Series - Options tab (Charts) Choose Format - Title (Charts) -Choose Format - Object Properties - Title dialog (Charts) +Choose Format - Format Selection - Title dialog (Charts) -Choose Format - Object Properties - Title dialog (Charts) +Choose Format - Format Selection - Title dialog (Charts) Choose Format - Title (Charts) Choose Format - Axis (Charts) -Choose Format - Legend, or Format - Object Properties - Legend (Charts) +Choose Format - Legend, or Format - Format Selection - Legend (Charts) Choose Format - Axis - X Axis/Secondary X Axis/Z Axis/All Axes (Charts) diff --git a/helpcontent2/source/text/schart/01/04010000.xhp b/helpcontent2/source/text/schart/01/04010000.xhp index 33ff18bbfa..3f79c5d42f 100644 --- a/helpcontent2/source/text/schart/01/04010000.xhp +++ b/helpcontent2/source/text/schart/01/04010000.xhp @@ -43,8 +43,8 @@ -Titles -Opens a dialog to enter or modify the titles in a chart. +Titles +Opens a dialog to enter or modify the titles in a chart. You can define the text for the main title, subtitle and the axis labels, and specify if they are displayed.
diff --git a/helpcontent2/source/text/schart/01/04020000.xhp b/helpcontent2/source/text/schart/01/04020000.xhp index 7853d2a62e..e05dfc7471 100644 --- a/helpcontent2/source/text/schart/01/04020000.xhp +++ b/helpcontent2/source/text/schart/01/04020000.xhp @@ -44,9 +44,9 @@ chart legends; hiding hiding;chart legends - + Legend -Opens the Legend dialog, which allows you to change the position of legends in the chart, and to specify whether the legend is displayed. +Opens the Legend dialog, which allows you to change the position of legends in the chart, and to specify whether the legend is displayed.
diff --git a/helpcontent2/source/text/schart/01/04030000.xhp b/helpcontent2/source/text/schart/01/04030000.xhp index 7f31d5ad0a..20ef489737 100644 --- a/helpcontent2/source/text/schart/01/04030000.xhp +++ b/helpcontent2/source/text/schart/01/04030000.xhp @@ -10,8 +10,8 @@ * * OpenOffice.org - a multi-platform office productivity suite * - * $RCSfile: 04030000.xhp,v $ - * $Revision: 1.11.34.1 $ + * $RCSfile: soffice2xmlhelp.xsl,v $ + * $Revision: 1.8 $ * * This file is part of OpenOffice.org. * @@ -35,63 +35,70 @@ - -Data Labels -/text/schart/01/04030000.xhp - - - + + Data Labels + /text/schart/01/04030000.xhp + + + data labels in charts -labels; for charts -charts; data labels -data values in charts -chart legends; showing icons with labels + labels; for charts + charts; data labels + data values in charts + chart legends; showing icons with labels - +
-Data Labels + Data Labels -Opens the Data Labels dialog, which enables you to set the data labels. + Opens the Data Labels dialog, which enables you to set the data labels. -
-
- -
+
+
+ If an element of a data series is selected, this command works on that data series only. If no element is selected, this command works on all data series. +
+
+ +
-Show value as number -Displays the absolute values of the data points. +Show value as number + Displays the absolute values of the data points. -Number format -Opens a dialog to select the number format. +Number format + Opens a dialog to select the number format. -Show value as percentage -Displays the percentage of the data points in each column. +Show value as percentage + Displays the percentage of the data points in each column. -Percentage format -Opens a dialog to select the percentage format. +Percentage format + Opens a dialog to select the percentage format. -Show category -Shows the data point text labels. +Show category + Shows the data point text labels. -Show legend key -Displays the legend icons next to each data point label. +Show legend key + Displays the legend icons next to each data point label. -Separator -Selects the separator between multiple text strings for the same object. +Separator + Selects the separator between multiple text strings for the same object. -Placement -Selects the placement of data labels relative to the objects. +Placement + Selects the placement of data labels relative to the objects. -Text Direction -Specify the text direction for a paragraph that uses complex text layout (CTL). This feature is only available if complex text layout support is enabled. - - +Text Direction + Specify the text direction for a paragraph that uses complex text layout (CTL). This feature is only available if complex text layout support is enabled. + + \ No newline at end of file diff --git a/helpcontent2/source/text/schart/01/04040000.xhp b/helpcontent2/source/text/schart/01/04040000.xhp index 8c9aed771b..da476ab884 100644 --- a/helpcontent2/source/text/schart/01/04040000.xhp +++ b/helpcontent2/source/text/schart/01/04040000.xhp @@ -51,8 +51,8 @@ axes; better scaling secondary axes in charts mw made "secondary axes;" a one level entry, deleted "charts; showing secondary axes" and generated one "axes;" enry out of two "axes;showing..." entries -Axes -Specifies the axes to be displayed in the chart. +Axes +Specifies the axes to be displayed in the chart.
diff --git a/helpcontent2/source/text/schart/01/04050000.xhp b/helpcontent2/source/text/schart/01/04050000.xhp index b990bdc4b5..582a853fbb 100644 --- a/helpcontent2/source/text/schart/01/04050000.xhp +++ b/helpcontent2/source/text/schart/01/04050000.xhp @@ -40,11 +40,11 @@ - - + Y Error Barsi85330 -Use the Y Error Bars dialog to display error bars for 2D charts. +Use the Y Error Bars dialog to display error bars for 2D charts. +
diff --git a/helpcontent2/source/text/schart/01/04050100.xhp b/helpcontent2/source/text/schart/01/04050100.xhp index 0386615f91..37a65ed1d8 100644 --- a/helpcontent2/source/text/schart/01/04050100.xhp +++ b/helpcontent2/source/text/schart/01/04050100.xhp @@ -11,7 +11,7 @@ * OpenOffice.org - a multi-platform office productivity suite * * $RCSfile: soffice2xmlhelp.xsl,v $ - * $Revision: 1.10 $ + * $Revision: 1.8 $ * * This file is part of OpenOffice.org. * @@ -46,11 +46,12 @@ trend lines in charts mean value lines in charts - -Trend Lines + +Trend Lines Regression curves, also known as trend lines, can be added to all 2D chart types except for Pie and Stock charts. +
None @@ -69,7 +70,7 @@ Shows the coefficient of determination next to the trend line. If you insert a trend line to a chart type that uses categories, like Line or Column, then the numbers 1, 2, 3, … are used as x-values to calculate the trend line. - + To insert trend lines for all data series, double-click the chart to enter edit mode. Choose Insert - Trend Lines, then select the type of trend line from None, Linear, Logarithmic, Exponential, or Power trend line. @@ -84,31 +85,31 @@ A trend line is shown in the legend automatically. - - -Mean Value Lines are special trend lines that show the mean value. Use Insert - Mean Value Lines to insert mean value lines for all data series. A single mean value line can be inserted by the Insert Mean Value Line command of the context menu of a data series. - The trend line has the same color as the corresponding data series. To change the line properties, select the trend line and choose Format - Object Properties - Line. + +Mean Value Lines are special trend lines that show the mean value. Use Insert - Mean Value Lines to insert mean value lines for data series. + + The trend line has the same color as the corresponding data series. To change the line properties, select the trend line and choose Format - Format Selection - Line. To show the trend line equation, select the trend line in the chart, right-click to open the context menu, and choose Insert Trend Line Equation. When the chart is in edit mode, %PRODUCTNAME gives you the equation of the trend line and the coefficient of determination R². Click on the trend line to see the information in the status bar. For a category chart (for example a line chart), the regression information is calculated using numbers 1, 2, 3, … as x-values. This is also true if your data series uses other numbers as names for the x-values. For such charts the XY chart type might be more suitable. - To show the equation and the coefficient of determination, select the regression curve and choose Format - Object Properties - Equation. see http://specs.openoffice.org/chart/DisplayTrendLineEquations.odthid + To show the equation and the coefficient of determination, select the regression curve and choose Format - Format Selection - Equation. see http://specs.openoffice.org/chart/DisplayTrendLineEquations.odthid Enable Show equation to see the equation of the regression curve.hid Enable Show Coefficient of Determination to see the determination coefficient of the regression curve. You can also calculate the parameters using Calc functions as follows. - The linear regression equation + The linear regression equation The linear regression follows the equation y=m*x+b. m = SLOPE(Data_Y;Data_X) b = INTERCEPT(Data_Y ;Data_X) Calculate the coefficient of determination by r² = RSQ(Data_Y;Data_X) Besides m, b and r² the array function LINEST provides additional statistics for a regression analysis. - The logarithm regression equation + The logarithm regression equation The logarithm regression follows the equation y=a*ln(x)+b. a = SLOPE(Data_Y;LN(Data_X)) b = INTERCEPT(Data_Y ;LN(Data_X)) r² = RSQ(Data_Y;LN(Data_X)) - The exponential regression equation + The exponential regression equation For exponential regression curves a transformation to a linear model takes place. The optimal curve fitting is related to the linear model and the results are interpreted accordingly. The exponential regression follows the equation y=b*exp(a*x) or y=b*m^x, which is transformed to ln(y)=ln(b)+a*x or ln(y)=ln(b)+ln(m)*x respectively. a = SLOPE(LN(Data_Y);Data_X) @@ -118,14 +119,14 @@ Calculate the coefficient of determination by r² = RSQ(LN(Data_Y);Data_X) Besides m, b and r² the array function LOGEST provides additional statistics for a regression analysis. - The power regression equation + The power regression equation For power regression curves a transformation to a linear model takes place. The power regression follows the equation y=b*x^a , which is transformed to ln(y)=ln(b)+a*ln(x). a = SLOPE(LN(Data_Y);LN(Data_X)) b = EXP(INTERCEPT(LN(Data_Y);LN(Data_X)) r² = RSQ(LN(Data_Y);LN(Data_X)) - ConstraintsUFI: is this still so? + ConstraintsUFI: is this still so? The calculation of the trend line considers only data pairs with the following values: - + logarithm regression: only positive x-values are considered, @@ -137,7 +138,7 @@ You should transform your data accordingly; it is best to work on a copy of the original data and transform the copied data. - The polynomial regression equation + The polynomial regression equation A polynomial regression curve cannot be added automatically. You must calculate this curve manually. Create a table with the columns x, x², x³, … , xⁿ, y up to the desired degree n. Use the formula =LINEST(Data_Y,Data_X) with the complete range x to xⁿ (without headings) as Data_X. @@ -147,4 +148,4 @@ Y Error Bars tab page
- + \ No newline at end of file diff --git a/helpcontent2/source/text/schart/01/04060000.xhp b/helpcontent2/source/text/schart/01/04060000.xhp index bd3c017fdc..15536a17e1 100755 --- a/helpcontent2/source/text/schart/01/04060000.xhp +++ b/helpcontent2/source/text/schart/01/04060000.xhp @@ -11,7 +11,7 @@ * OpenOffice.org - a multi-platform office productivity suite * * $RCSfile: soffice2xmlhelp.xsl,v $ - * $Revision: 1.10 $ + * $Revision: 1.8 $ * * This file is part of OpenOffice.org. * @@ -56,29 +56,29 @@ In this area you can choose between two Y axis scaling modes. The axes can only be scaled and given properties separately. -Primary Y axis +Primary Y axis This option is active as default. All data series are aligned to the primary Y axis. -Secondary Y axis +Secondary Y axis Changes the scaling of the Y axis. This axis is only visible when at least one data series is assigned to it and the axis view is active. Settings Define the settings for a bar chart in this area. Any changes apply to all data series of the chart, not to the selected data only. -Spacing +Spacing Defines the spacing between the columns in percent. The maximal spacing is 600%. -Overlap +Overlap Defines the necessary settings for overlapping data series. You can choose between -100 and +100%. -Connection Lines For "stacked" and "percent" column (vertical bar) charts, mark this check box to connect the column layers that belong together with lines. -Show bars side by side +Show bars side by side If two axes are shown in a bar chart, and some data series are attached to the first axis, while some other data series are attached to the second axis, then both sets of data series are shown independently, overlapping each other. As a result, bars attached to the first y-axis are partly or completely hidden by bars attached to the second y-axis. To avoid this, enable the option to display bars side by side. The bars from different data series are shown as if they were attached only to one axis. @@ -90,20 +90,21 @@ In 3D pie and donut charts that were created with older versions of the software, the starting angle is 0 degrees instead of 90 degrees. For old and new 2D charts the default starting angle is 90 degrees. When you change the starting angle or the direction, only current versions of the software show the changed values. Older versions of the software display the same document using the default values: Always counterclockwise direction and a starting value of 90 degrees (2D pie charts) or 0 degrees (3D pie charts). -Degrees +Degrees Enter the starting angle between 0 and 359 degrees. You can also click the arrows to change the displayed value. Plot missing values Sometimes values are missing in a data series that is shown in a chart. You can select from different options how to plot the missing values. The options are available for some chart types only. -Leave gap +Leave gap For a missing value, no data will be shown. This is the default for chart types Column, Bar, Line, Net. -Assume zero +Assume zero For a missing value, the y-value will be shown as zero. This is the default for chart type Area. -Continue line +Continue line For a missing value, the interpolation from the neighbor values will be shown. This is the default for chart type XY. - Plot values from hidden cells + +Include values from hidden cells Check to also show values of currently hidden cells within the source cell range. \ No newline at end of file diff --git a/helpcontent2/source/text/schart/01/04070000.xhp b/helpcontent2/source/text/schart/01/04070000.xhp index 95d2e02b27..0b1b170a4f 100644 --- a/helpcontent2/source/text/schart/01/04070000.xhp +++ b/helpcontent2/source/text/schart/01/04070000.xhp @@ -48,9 +48,9 @@ axes; inserting grids grids; inserting in charts - + Grids -You can divide the axes into sections by assigning gridlines to them. This allows you to get a better overview of the chart, especially if you are working with large charts. +You can divide the axes into sections by assigning gridlines to them. This allows you to get a better overview of the chart, especially if you are working with large charts. The Y axis major grid is activated by default.
diff --git a/helpcontent2/source/text/schart/01/05010000.xhp b/helpcontent2/source/text/schart/01/05010000.xhp index 5ba1a8b5c5..817dec6cfe 100644 --- a/helpcontent2/source/text/schart/01/05010000.xhp +++ b/helpcontent2/source/text/schart/01/05010000.xhp @@ -36,22 +36,18 @@ -Object Properties +Format Selection /text/schart/01/05010000.xhp - -Sun Microsystems, Inc. -converted from old format - fpe - objects;properties of charts charts; properties properties;charts mw changed "properties;" - -Object Properties -Assigns certain properties to the selected object. + +Format Selection +Formats the selected object. Depending on the object selected, the command opens dialogs that you can also open by choosing the following commands from the Format menu:
diff --git a/helpcontent2/source/text/schart/01/05010100.xhp b/helpcontent2/source/text/schart/01/05010100.xhp index 8b715fa095..660df56330 100644 --- a/helpcontent2/source/text/schart/01/05010100.xhp +++ b/helpcontent2/source/text/schart/01/05010100.xhp @@ -46,7 +46,7 @@
Data Point - This dialog allows you to change the properties of a selected data point. The dialog appears when there is only one data point selected when you choose Format - Object Properties. Some of the menu entries are only available for 2D or 3D charts. + This dialog allows you to change the properties of a selected data point. The dialog appears when there is only one data point selected when you choose Format - Format Selection. Some of the menu entries are only available for 2D or 3D charts.
Any changes made only affect this one data point. For example, if you edit the color of a bar, only the color of that bar will be different.
diff --git a/helpcontent2/source/text/schart/01/05010200.xhp b/helpcontent2/source/text/schart/01/05010200.xhp index d7d3b263b0..abfee069f3 100644 --- a/helpcontent2/source/text/schart/01/05010200.xhp +++ b/helpcontent2/source/text/schart/01/05010200.xhp @@ -45,7 +45,7 @@
Data Series -Use this to change the properties of a selected data series. This dialog appears when one data series is selected when you choose Format - Object Properties. Some of the menu entries are only available for 2D or 3D charts. +Use this to change the properties of a selected data series. This dialog appears when one data series is selected when you choose Format - Format Selection. Some of the menu entries are only available for 2D or 3D charts.
Any changes made here affect the entire data series. For example, if you change the color, all elements belonging to this data series will change color.
diff --git a/helpcontent2/source/text/schart/01/05020100.xhp b/helpcontent2/source/text/schart/01/05020100.xhp index bcc3a69d70..f6cb11933f 100644 --- a/helpcontent2/source/text/schart/01/05020100.xhp +++ b/helpcontent2/source/text/schart/01/05020100.xhp @@ -1,8 +1,8 @@ - - + + + - - -Title -/text/schart/01/05020100.xhp - - -Sun Microsystems, Inc. -converted from old format - fpe - - - + + Title + /text/schart/01/05020100.xhp + + + editing; titles -moved the subtitle bookmark here from 0502020 -Title -Modifies the properties of the selected title. + + +moved the subtitle bookmark here from 0502020 +Title + Modifies the properties of the selected title. -
- -
- - - -Character - - - - - +
+ +
+ + + + Character + + + + + \ No newline at end of file diff --git a/helpcontent2/source/text/schart/01/three_d_view.xhp b/helpcontent2/source/text/schart/01/three_d_view.xhp index 8c64baccd5..83175cd14a 100644 --- a/helpcontent2/source/text/schart/01/three_d_view.xhp +++ b/helpcontent2/source/text/schart/01/three_d_view.xhp @@ -1,9 +1,8 @@ - - - + + - - - + + - -3D View -/text/schart/01/three_d_view.xhp - - - + + 3D View + /text/schart/01/three_d_view.xhp + + + 3D charts -charts; 3D views -illumination; 3D charts + charts; 3D views + illumination; 3D charts -mw made "3D charts;" a one level entry3D View +mw made "3D charts;" a one level entry +3D View -On the first page of the Chart Wizard or in the context menu of a chart you can choose a chart type. Enables a three dimensional view for Column, Bar, Pie, and Area charts. For Line and XY (Scatter) charts you can see 3D lines.must be AHID, see i80656 -
- -
- -The chart preview responds to the new settings that you enter in the dialog. - - -When you leave the dialog with OK, the settings are applied permanently. - - -When you leave the dialog with Cancel or Escape, the chart returns to the state when you opened the dialog. - - -For a 3D chart you can choose Format - 3D View to set perspective, appearance and illumination. -Perspective - - -Enter the values for rotation of the chart on the three axes and for a perspective view. - - -Set all angles to 0 for a front view of the chart. Pie charts and donut charts are shown as circles. -With Right-angled axes enabled, you can rotate the chart contents only in X and Y direction, that is, parallel to the chart borders. -An x value of 90, with y and z set to 0, provides a view from top down to the chart. With x set to -90, you see the bottom of the chart. -The rotations are applied in the order first x, then y, last z. -When shading is enabled and you rotate a chart, the lights are rotated as if they are fixed to the chart. -The rotation axes always relate to the page, not to the chart's axes. This is different from some other chart programs. -Select the Perspective check box to view the chart in central perspective as through a camera lens instead of using a parallel projection. -Set the focus length with the spin button. 100% gives a perspective view where a far edge in the chart looks approximately half as big as a near edge. -Older versions of %PRODUCTNAME cannot display the percentage of perspective the same way as the current version.Right-angled axes -If Right-angled axes is enabled, you can rotate the chart contents only in X and Y direction, that is, parallel to the chart borders. Right-angled axes is enabled by default for newly created 3D charts. Pie and Donut charts do not support right-angled axes.X rotation -Sets the rotation of the chart on the x axis. The preview responds to the new settings.Y rotation -Sets the rotation of the chart on the y axis. The preview responds to the new settings.z rotation -Sets the rotation of the chart on the z axis. The preview responds to the new settings.perspective + On the first page of the Chart Wizard or in the context menu of a chart you can choose a chart type. Opens a dialog to edit the properties of a three dimensional view for Column, Bar, Pie, and Area charts. For Line and XY (Scatter) charts you can see 3D lines.must be AHID, see i80656 +
+ +
+ + The chart preview responds to the new settings that you enter in the dialog. + + + When you leave the dialog with OK, the settings are applied permanently. + + + When you leave the dialog with Cancel or Escape, the chart returns to the state when you opened the dialog. + + + For a 3D chart you can choose Format - 3D View to set perspective, appearance and illumination. + Perspective + + + Enter the values for rotation of the chart on the three axes and for a perspective view. + + + Set all angles to 0 for a front view of the chart. Pie charts and donut charts are shown as circles. + With Right-angled axes enabled, you can rotate the chart contents only in X and Y direction, that is, parallel to the chart borders. + An x value of 90, with y and z set to 0, provides a view from top down to the chart. With x set to -90, you see the bottom of the chart. + The rotations are applied in the order first x, then y, last z. + When shading is enabled and you rotate a chart, the lights are rotated as if they are fixed to the chart. + The rotation axes always relate to the page, not to the chart's axes. This is different from some other chart programs. + Select the Perspective check box to view the chart in central perspective as through a camera lens instead of using a parallel projection. + Set the focus length with the spin button. 100% gives a perspective view where a far edge in the chart looks approximately half as big as a near edge. + Older versions of %PRODUCTNAME cannot display the percentage of perspective the same way as the current version.Right-angled axes + +If Right-angled axes is enabled, you can rotate the chart contents only in X and Y direction, that is, parallel to the chart borders. Right-angled axes is enabled by default for newly created 3D charts. Pie and Donut charts do not support right-angled axes.X rotation + +Sets the rotation of the chart on the x axis. The preview responds to the new settings.Y rotation + +Sets the rotation of the chart on the y axis. The preview responds to the new settings.z rotation + +Sets the rotation of the chart on the z axis. The preview responds to the new settings.perspective -Mark the Perspective box to view the chart as through a camera lens. Use the spin button to set the percentage. With a high percentage nearer objects look bigger than more distant objects. -Appearance - - -Select a scheme from the list box. - - -By selecting a scheme, the check boxes and the light sources are set accordingly. - - -If you mark or unmark a combination of check boxes that is not given by the Realistic or Simple scheme, you create a Custom scheme. - - -Mark Shading to use the Gouraud method for rendering the surface, otherwise a flat method is used. -The flat method sets a single color and brightness for each polygon. The edges are visible, soft gradients and spot lights are not possible. -The Gouraud method applies gradients for a smoother, more realistic look.Regina: Need an external article on web, which describes the 3D engine in detail. Till that, the user should get some information on Gouraud and Flat. - - - - -Mark Object Borders to draw lines along the edges. - - -Mark Rounded Edges to smooth the edges of box shapes. - -Scheme -Select a scheme from the list box, or click any of the check boxes below.Shading -Applies Gouraud shading if marked, or flat shading if unmarked.Object borders -Shows borders around the areas by setting the line style to Solid.Rounded Edges -Edges are rounded by 5%. -Illumination -Set the light sources for the 3D view. - - -Click any of the eight buttons to switch a directed light source on or off. -By default, the second light source is switched on. It is the first of seven "normal", uniform light sources. The light source number one projects a specular light with highlights. - - -For the selected light source, you can then choose a color and intensity in the list box just below the eight buttons. The brightness values of all lights are added, so use dark colors when you enable multiple lights. - - -The small preview inside this tab page has two sliders to set the vertical and horizontal position of the selected light source. The light source always aims to the middle of the object. - - -The button in the corner of the small preview switches the internal illumination model between a sphere and a cube.Regina: Are you sure? I thought, that it only toggles the preview in the dialog. - - -Use the Ambient light list box to define the ambient light which shines with a uniform intensity from all directions. - -preview right bar -Drag the right slider to set the vertical height and direction of the selected light source.preview bottom bar -Drag the bottom slider to set the horizontal position and direction of the selected light source.preview right bottom button -Click to switch between an illumination model of a sphere or a cube.Light source -Click to enable or disable the specular light source with highlights. + +Mark the Perspective box to view the chart as through a camera lens. Use the spin button to set the percentage. With a high percentage nearer objects look bigger than more distant objects. + Appearance + + + Select a scheme from the list box. + + + By selecting a scheme, the check boxes and the light sources are set accordingly. + + + If you mark or unmark a combination of check boxes that is not given by the Realistic or Simple scheme, you create a Custom scheme. + + + Mark Shading to use the Gouraud method for rendering the surface, otherwise a flat method is used. + The flat method sets a single color and brightness for each polygon. The edges are visible, soft gradients and spot lights are not possible. + The Gouraud method applies gradients for a smoother, more realistic look.Regina: Need an external article on web, which describes the 3D engine in detail. Till that, the user should get some information on Gouraud and Flat. + + + + + Mark Object Borders to draw lines along the edges. + + + Mark Rounded Edges to smooth the edges of box shapes. + + Scheme + +Select a scheme from the list box, or click any of the check boxes below.Shading + +Applies Gouraud shading if marked, or flat shading if unmarked.Object borders + +Shows borders around the areas by setting the line style to Solid.Rounded Edges + +Edges are rounded by 5%. + Illumination + Set the light sources for the 3D view. + + + Click any of the eight buttons to switch a directed light source on or off. + By default, the second light source is switched on. It is the first of seven "normal", uniform light sources. The light source number one projects a specular light with highlights. + + + For the selected light source, you can then choose a color and intensity in the list box just below the eight buttons. The brightness values of all lights are added, so use dark colors when you enable multiple lights. + + + The small preview inside this tab page has two sliders to set the vertical and horizontal position of the selected light source. The light source always aims to the middle of the object. + + + The button in the corner of the small preview switches the internal illumination model between a sphere and a cube.Regina: Are you sure? I thought, that it only toggles the preview in the dialog. + + + Use the Ambient light list box to define the ambient light which shines with a uniform intensity from all directions. + + preview right bar + +Drag the right slider to set the vertical height and direction of the selected light source.preview bottom bar + +Drag the bottom slider to set the horizontal position and direction of the selected light source.preview right bottom button + +Click to switch between an illumination model of a sphere or a cube.Light source + +Click to enable or disable the specular light source with highlights. -Click to enable or disable the uniform light source. -Select a color for the selected light source. -Select a color using the color dialog.Ambient light -Select a color for the ambient light. -Select a color using the color dialog. -
- - - - - -
- - + +Click to enable or disable the uniform light source. + +Select a color for the selected light source. + +Select a color using the color dialog.Ambient light + +Select a color for the ambient light. + +Select a color using the color dialog. +
+ + + + + +
+ + \ No newline at end of file diff --git a/helpcontent2/source/text/schart/01/type_stock.xhp b/helpcontent2/source/text/schart/01/type_stock.xhp index 230e8aada7..3290c9a0ce 100644 --- a/helpcontent2/source/text/schart/01/type_stock.xhp +++ b/helpcontent2/source/text/schart/01/type_stock.xhp @@ -1,9 +1,8 @@ - - - + + - - - + + - -Chart Type Stock -/text/schart/01/type_stock.xhp - - - + + Chart Type Stock + /text/schart/01/type_stock.xhp + + + stock charts -chart types;stock -data sources;setting for stock charts -mw added one entryChart Type Stock + chart types;stock + data sources;setting for stock charts +mw added one entry +Chart Type Stock -On the first page of the Chart Wizard you can choose a chart type. -
- -
-Stock -A Stock chart illustrates the market trend given by opening price, bottom price, top price and closing price. The transaction volume can also be shown.UFI: should we show example charts for every type? -For a Stock chart the order of the data series is important. The data should be arranged as shown in the example table below. - - - - -A - - -B - - -C - - -D - - -E - - -F - - - - -1 - - - -Transaction volume - - -Opening price - - -Low (bottom price) - - -High (top price) - - -Closing price - - - - -2 - - -Monday - - -2500 - - -20 - - -15 - - -25 - - -17 - - - - -3 - - -Tuesday - - -3500 - - -32 - - -22 - - -37 - - -30 - - - - -4 - - -Wednesday - - -1000 - - -15 - - -15 - - -17 - - -17 - - - - -5 - - -Thursday - - -2200 - - -40 - - -30 - - -47 - - -35 - - - - -6 - - -Friday - - -4600 - - -27 - - -20 - - -32 - - -31 - - -
-The open, low, high, and closing values of a row build together one data unit in the chart. A stock price data series consists of several rows containing such data units. The column containing the transaction volume builds an optional second data series. -Depending on the chosen variant, you do not need all columns. -Stock Chart Variants -Choose the Stock chart type on the first page of the Chart wizard. Then select one of the four variants. -Type 1 -Based on low -and high column the Type 1 shows the distance between bottom price (low) and top price (high) by a vertical line. -Based on low, high, and close column Type 1 shows an additional horizontal mark for the closing price. -Type 2 -Based on open, low, high, and close column Type 2 generates the traditional "candle stick" chart. Type 2 draws the vertical line between the bottom and top price and adds a rectangle in front, which visualizes the range between the opening and closing price. If you click on the rectangle you see more information in the status bar. %PRODUCTNAME uses different fill colors for rising values (the opening price is lower than the closing price) and falling values. -Type 3 -Based on volume, low, high, and close column chart Type 3 draws a chart like Type 1, with additional columns for the transaction volume.i80596 -Type 4 -Based on all five data columns volume, open, low, high, and close, Type 4 combines a chart of Type 2 with a column chart for the transaction volume. -Because measurement for transaction volume might be "units", a second y axis is introduced in chart Type 3 and Type 4. The price axis is shown on the right side and the volume axis on the left side. -Setting the Data Source -Charts based on its own data -To change the data series of a chart having its own data, choose Chart Data Table from the View menu or from the context menu of the chart in edit mode. -In an embedded chart data table, the data series are always organized in columns. -For a new stock chart first use a column chart. Add the columns you need and enter your data in the order which is shown in the example, omitting any columns not required for the desired variant. Use Move Series Right to change the column order. Close the chart data table. Now use the Chart Type dialog to change to the stock chart variant. -If you have already got a stock chart and you want to change the variant, then first change the chart type to a column chart, add or remove columns so that it fits to the variant, and then change the chart type back to a stock chart.Watch issue 72433 to see whether a change in the handling is done. -Do not write the name of a data series in a row. Write the name into the field above the role name. -The order of the rows determines how the categories are arranged in the chart. Use Move Row Down to change the order. -Charts based on Calc or Writer tables -You can choose or alter a data range on the second page of the Chart wizard or in the Data Range dialog. For fine tuning use the Data Series dialog. -To specify a data range do one of the following: - - -Enter the data range in the text box. -In Calc, an example data range would be "$Sheet1.$B$3:$B$14". Note that a data range may consist of more than one region in a spreadsheet, e.g. "$Sheet1.A1:A5;$Sheet1.D1:D5" is also a valid data range. In Writer, an example data range would be "Table1.A1:E4". -As long as the syntax is not correct, %PRODUCTNAME shows the text in red. - - - - -In Calc, click Select data range to minimize the dialog, then drag to select the data range. When you release the mouse, the data are entered. Click Select data range again to add a data range. In the input field of the minimized dialog, click after the entry and type a semicolon. Then drag to select the next range. - - -Click one of the options for data series in rows or in columns. -Your stock chart data are "in columns", if the information in a row belongs to the same "candle stick".I don't know whether copying a table based chart to draw or impress needs chart data arranged in columns, and I cannot test it, because the clipboard is broken. -Fine Tuning the Data Ranges of Table Based Stock Charts -You can organize data series and edit the source for parts of single data series on the third page of the Chart wizard or on the page Data Series in the Data Range dialog. -Organize Data Series -In the data series area on the left side of the dialog, you can organize the data series of the actual chart. A stock chart has at least one data series containing the prices. It might have a second data series for transaction volume. -If you have got more than one price data series, use the Up and Down arrow buttons to order them. The order determines the arrangement in the chart. Do the same for volume data series. You cannot switch price and volume data series. -To remove a data series, select the data series in the list and click Remove. -To add a data series, select one of the existing data series and click Add. You get an empty entry below the selected one, which has the same type. If you have no price data series or no volume data series, you must first select a range for these series in the Data Range dialog.Regina: The behavior is odd, but I don't know a better solution. Therefore I have not written an issue. -Setting Data Ranges -In the Data Ranges dialog you can set or change the data range of each component of the selected data series. -In the upper list you see the role name of the components and the current values. When you have selected a role, you can change the value in the text box below the list. The label shows the selected role.deleted a para, see i80596Enter the range into the text box or click on Select data range to minimize the dialog and select the range with the mouse. -Select Open Values, Close Values, High Values, and Low Values in any order. Specify only the ranges for those roles which you need for the chosen variant of the stock chart. The ranges need not be next to each other in the table. -Legend -The legend displays the labels from the first row or column or from the special range that you have set in the Data Series dialog. If your chart does not contain labels, the legend displays text like "Row 1, Row 2, ...", or "Column A, Column B, ..." according to the row number or column letter of the chart data.deleted 3 parasThe legend shows the value from the range, which you entered in the Range for Name field in the Data Range dialog. The default entry is the column header of the closing price column. -Select one of the position options. When the chart is finished, you can specify other positions using the Format menu. -
- - - - - -
- - + On the first page of the Chart Wizard you can choose a chart type. +
+ +
+ Stock + A Stock chart illustrates the market trend given by opening price, bottom price, top price and closing price. The transaction volume can also be shown.UFI: should we show example charts for every type? + For a Stock chart the order of the data series is important. The data should be arranged as shown in the example table below. + + + + + + A + + + B + + + C + + + D + + + E + + + F + + + + + 1 + + + + + Transaction volume + + + Opening price + + + Low (bottom price) + + + High (top price) + + + Closing price + + + + + 2 + + + Monday + + + 2500 + + + 20 + + + 15 + + + 25 + + + 17 + + + + + 3 + + + Tuesday + + + 3500 + + + 32 + + + 22 + + + 37 + + + 30 + + + + + 4 + + + Wednesday + + + 1000 + + + 15 + + + 15 + + + 17 + + + 17 + + + + + 5 + + + Thursday + + + 2200 + + + 40 + + + 30 + + + 47 + + + 35 + + + + + 6 + + + Friday + + + 4600 + + + 27 + + + 20 + + + 32 + + + 31 + + +
+ + The open, low, high, and closing values of a row build together one data unit in the chart. A stock price data series consists of several rows containing such data units. The column containing the transaction volume builds an optional second data series. + Depending on the chosen variant, you do not need all columns. + Stock Chart Variants + Choose the Stock chart type on the first page of the Chart wizard. Then select one of the four variants. + Type 1 + Based on low + and high column the Type 1 shows the distance between bottom price (low) and top price (high) by a vertical line. + Based on low, high, and close column Type 1 shows an additional horizontal mark for the closing price. + Type 2 + Based on open, low, high, and close column Type 2 generates the traditional "candle stick" chart. Type 2 draws the vertical line between the bottom and top price and adds a rectangle in front, which visualizes the range between the opening and closing price. If you click on the rectangle you see more information in the status bar. %PRODUCTNAME uses different fill colors for rising values (the opening price is lower than the closing price) and falling values. + Type 3 + Based on volume, low, high, and close column chart Type 3 draws a chart like Type 1, with additional columns for the transaction volume.i80596 + Type 4 + Based on all five data columns volume, open, low, high, and close, Type 4 combines a chart of Type 2 with a column chart for the transaction volume. + Because measurement for transaction volume might be "units", a second y axis is introduced in chart Type 3 and Type 4. The price axis is shown on the right side and the volume axis on the left side. + Setting the Data Source + Charts based on its own data + To change the data series of a chart having its own data, choose Chart Data Table from the View menu or from the context menu of the chart in edit mode. + In an embedded chart data table, the data series are always organized in columns. + For a new stock chart first use a column chart. Add the columns you need and enter your data in the order which is shown in the example, omitting any columns not required for the desired variant. Use Move Series Right to change the column order. Close the chart data table. Now use the Chart Type dialog to change to the stock chart variant. + If you have already got a stock chart and you want to change the variant, then first change the chart type to a column chart, add or remove columns so that it fits to the variant, and then change the chart type back to a stock chart.Watch issue 72433 to see whether a change in the handling is done. + Do not write the name of a data series in a row. Write the name into the field above the role name. + The order of the rows determines how the categories are arranged in the chart. Use Move Row Down to change the order. + Charts based on Calc or Writer tables + You can choose or alter a data range on the second page of the Chart wizard or in the Data Range dialog. For fine tuning use the Data Series dialog. + To specify a data range do one of the following: + + + Enter the data range in the text box. + In Calc, an example data range would be "$Sheet1.$B$3:$B$14". Note that a data range may consist of more than one region in a spreadsheet, e.g. "$Sheet1.A1:A5;$Sheet1.D1:D5" is also a valid data range. In Writer, an example data range would be "Table1.A1:E4". + As long as the syntax is not correct, %PRODUCTNAME shows the text in red. + + + + + In Calc, click Select data range to minimize the dialog, then drag to select the data range. When you release the mouse, the data are entered. Click Select + data range again to add a data range. In the input field of the minimized dialog, click after the entry and type a semicolon. Then drag to select the next range. + + + Click one of the options for data series in rows or in columns. + Your stock chart data are "in columns", if the information in a row belongs to the same "candle stick".I don't know whether copying a table based chart to draw or impress needs chart data arranged in columns, and I cannot test it, because the clipboard is broken. + Fine Tuning the Data Ranges of Table Based Stock Charts + You can organize data series and edit the source for parts of single data series on the third page of the Chart wizard or on the page Data Series in the Data Range dialog. + Organize Data Series + In the data series area on the left side of the dialog, you can organize the data series of the actual chart. A stock chart has at least one data series containing the prices. It might have a second data series for transaction volume. + If you have got more than one price data series, use the Up and Down arrow buttons to order them. The order determines the arrangement in the chart. Do the same for volume data series. You cannot switch price and volume data series. + To remove a data series, select the data series in the list and click Remove. + To add a data series, select one of the existing data series and click Add. You get an empty entry below the selected one, which has the same type. If you have no price data series or no volume data series, you must first select a range for these series in the Data Range dialog.Regina: The behavior is odd, but I don't know a better solution. Therefore I have not written an issue. + Setting Data Ranges + In the Data Ranges dialog you can set or change the data range of each component of the selected data series. + In the upper list you see the role name of the components and the current values. When you have selected a role, you can change the value in the text box below the list. The label shows the selected role.deleted a para, see i80596 +Enter the range into the text box or click on Select data range to minimize the dialog and select the range with the mouse. + Select Open Values, Close Values, High Values, and Low Values in any order. Specify only the ranges for those roles which you need for the chosen variant of the stock chart. The ranges need not be next to each other in the table. + Legend + The legend displays the labels from the first row or column or from the special range that you have set in the Data Series dialog. If your chart does not contain labels, the legend displays text like "Row 1, Row 2, ...", or "Column A, Column B, ..." according to the row number or column letter of the chart data.deleted 3 paras +The legend shows the value from the range, which you entered in the Range for Name field in the Data Range dialog. The default entry is the column header of the closing price column. + Select one of the position options. When the chart is finished, you can specify other positions using the Format menu. +
+ + + + + +
+ + \ No newline at end of file diff --git a/helpcontent2/source/text/schart/main0000.xhp b/helpcontent2/source/text/schart/main0000.xhp index 651ac2e471..19d9cc6c67 100755 --- a/helpcontent2/source/text/schart/main0000.xhp +++ b/helpcontent2/source/text/schart/main0000.xhp @@ -1,9 +1,8 @@ - - - + + - - - + + - -Charts in $[officename] -/text/schart/main0000.xhp - - - + + Charts in $[officename] + /text/schart/main0000.xhp + + + charts; overview -HowTos for charts -MW added one entryUsing Charts in %PRODUCTNAME + HowTos for charts +MW added one entry +Using Charts in %PRODUCTNAME -$[officename] lets you present data graphically in a chart, so that you can visually compare data series and view trends in the data. You can insert charts into spreadsheets, text documents, drawings, and presentations. + $[officename] lets you present data graphically in a chart, so that you can visually compare data series and view trends in the data. You can insert charts into spreadsheets, text documents, drawings, and presentations. -Chart Data -Charts can be based on the following data: - - -Spreadsheet values from Calc cell rangesalso Excel... - - -Cell values from a Writer table - - -Values that you enter in the Chart Data Table dialog (you can create these charts in Writer, Draw, or Impress, and you can copy and paste them also to Calc) - -command line Insert - (Object -) Chart, moved here from deleted shared/01/04160100.xhp + Chart Data + Charts can be based on the following data: + + + Spreadsheet values from Calc cell rangesalso Excel... + + + Cell values from a Writer table + + + Values that you enter in the Chart Data Table dialog (you can create these charts in Writer, Draw, or Impress, and you can copy and paste them also to Calc) + + command line Insert - (Object -) Chart, moved here from deleted shared/01/04160100.xhp -Creates a chart in the current document. To use a range of cells as the data source for your chart, select the cells, and then choose this command. -To insert a chart - - -To edit a chart - - -Click a chart to edit the chart object properties: -size and position on the current page -alignment, text wrap, outer borders, and more - - -Double-click a chart to enter the chart edit mode: -chart data values (for charts with own data) -chart type, axes, titles, walls, grid, and more - - -Double-click a chart element in chart edit mode: -double-click an axis to edit the scale, type, color, and more -double-click a data point, or a data series in the legend, to edit the graphical values of the data series -with a data series selected, double-click a single data point to edit the properties of this data point (for example, a single bar in a bar chart) -double-click any other chart element, or click the element and open the Format menu, to edit the properties - - -Click outside the chart to leave the current edit mode. - - -To print a chart in high quality, you can export the chart to a PDF file and print that file.how to update chart data (drag&drop vs chart data dialog) - - - - - - + +Creates a chart in the current document. To use a continuous range of cells as the data source for your chart, click inside the cell range, and then choose this command. Alternatively, select some cells and choose this command to create a chart of the selected cells. + To insert a chart + + + To edit a chart + + + Click a chart to edit the object properties: + Size and position on the current page. + Alignment, text wrap, outer borders, and more. + + + Double-click a chart to enter the chart edit mode: + Chart data values (for charts with own data). + Chart type, axes, titles, walls, grid, and more. + + + Double-click a chart element in chart edit mode: + Double-click an axis to edit the scale, type, color, and more. + Double-click a data point, or a data series in the legend, to edit the graphical values of the data series. + With a data series selected, double-click a single data point to edit the properties of this data point (for example, a single bar in a bar chart). + Double-click any other chart element, or click the element and open the Format menu, to edit the properties. + + + Click outside the chart to leave the current edit mode. + + + To print a chart in high quality, you can export the chart to a PDF file and print that file. + In chart edit mode, you see the Formatting Bar for charts. + You can right-click an element of a chart to open the context menu. The context menu offers many commands to format the selected element. + +Formats the selected title. + +Formats the chart area. + +Formats the chart wall. + +Formats the chart floor. + +Formats the chart legend. + +Formats the selected axis. + +Formats the selected data point. + +Formats the major grid. + +Formats the minor grid. + +Formats the data series. + +Formats the stock loss indicators. + +Formats the stock gain indicators. + +Formats the data lables. + +Formats the Y error bars. + +Formats the mean value line. + +Formats the trendline. + +Formats the trendline equation. + +Formats the selected data label. + +Opens a dialog to insert chart titles. + +Opens a dialog to insert or delete axes. + +Opens a dialog to insert an axis. + +Opens a dialog to insert an axis title. + +Inserts a major grid. + +Inserts a minor grid. + +Inserts data labels. + +Inserts the trendline equation and the coefficient of determination R². + +Inserts the coefficient of determination R² value. + +Inserts a single data label. + +Deletes the chart legend. + +Deletes the selected axis. + +Deletes the major grid. + +Deletes the minor grid. + +Deletes all data labels. + +Deletes the trendline equation. + +Deletes the R² value. + +Deletes the selected data label. + +Deletes the mean value line. + +Deletes the Y error bars. + +Resets the selected data point to default format. + +Resets all data points to default format.how to update chart data (drag&drop vs chart data dialog) + + + + + + \ No newline at end of file diff --git a/helpcontent2/source/text/schart/main0202.xhp b/helpcontent2/source/text/schart/main0202.xhp new file mode 100755 index 0000000000..c2a5ecdf08 --- /dev/null +++ b/helpcontent2/source/text/schart/main0202.xhp @@ -0,0 +1,67 @@ + + + + + + + + + Formatting Bar + /text/schart/main0202.xhp + + + +
+ Formatting Bar + The Formatting Bar is shown when a chart is set to edit mode. Double-click a chart to enter edit mode. Click outside the chart to leave edit mode. +
+ You can edit the formatting of a chart using the controls and icons on the Formatting Bar. + +Select Chart Element + Select the element from the chart that you want to format. The element gets selected in the chart preview. Click Format Selection to open the properties dialog for the selected element. + Format Selection + Opens the properties dialog for the selected element. + Chart Type + Opens the Chart Type dialog. + Chart Data Table + Opens the Data Table dialog where you can edit the chart data. + Horizontal Grid On/Off + The Horizontal Grid On/Off icon on the Formatting bar toggles the visibility of the grid display for the X axis. Note: This only works if the Minor grid check boxes in Insert - Grids are cleared. + Legend On/Off + To show or hide a legend, click Legend On/Off on the Formatting bar. + Scale Text + Rescales the text in the chart when you change the size of the chart. + Automatic Layout + Moves all chart elements to their default positions inside the current chart. This function does not alter the chart type or any other attributes other than the position of elements. + + \ No newline at end of file diff --git a/helpcontent2/source/text/schart/makefile.mk b/helpcontent2/source/text/schart/makefile.mk index 463e6311b6..43822b4c47 100644 --- a/helpcontent2/source/text/schart/makefile.mk +++ b/helpcontent2/source/text/schart/makefile.mk @@ -49,6 +49,7 @@ MODULE = schart # this list matches the *.xhp files to process XHPFILES = \ main0000.xhp \ + main0202.xhp \ main0503.xhp # --- Targets ------------------------------------------------------ diff --git a/helpcontent2/util/scalc/makefile.mk b/helpcontent2/util/scalc/makefile.mk index c5639ba9a4..61bbcef62f 100644 --- a/helpcontent2/util/scalc/makefile.mk +++ b/helpcontent2/util/scalc/makefile.mk @@ -1309,6 +1309,7 @@ LINKLINKFILES= \ text$/schart$/02$/02020000.xhp \ text$/schart$/04$/01020000.xhp \ text$/schart$/main0000.xhp \ + text$/schart$/main0202.xhp \ text$/schart$/main0503.xhp \ diff --git a/helpcontent2/util/schart/makefile.mk b/helpcontent2/util/schart/makefile.mk index 7ae0d0c373..c40f0ebb83 100644 --- a/helpcontent2/util/schart/makefile.mk +++ b/helpcontent2/util/schart/makefile.mk @@ -998,6 +998,7 @@ LINKLINKFILES= \ text$/schart$/02$/02020000.xhp \ text$/schart$/04$/01020000.xhp \ text$/schart$/main0000.xhp \ + text$/schart$/main0202.xhp \ text$/schart$/main0503.xhp \ diff --git a/helpcontent2/util/sdraw/makefile.mk b/helpcontent2/util/sdraw/makefile.mk index 868a878f5e..18caa9f7f6 100644 --- a/helpcontent2/util/sdraw/makefile.mk +++ b/helpcontent2/util/sdraw/makefile.mk @@ -1231,6 +1231,7 @@ LINKLINKFILES= \ text$/schart$/02$/02020000.xhp \ text$/schart$/04$/01020000.xhp \ text$/schart$/main0000.xhp \ + text$/schart$/main0202.xhp \ text$/schart$/main0503.xhp \ diff --git a/helpcontent2/util/simpress/makefile.mk b/helpcontent2/util/simpress/makefile.mk index 74d5e8850c..a6ab94b35d 100644 --- a/helpcontent2/util/simpress/makefile.mk +++ b/helpcontent2/util/simpress/makefile.mk @@ -1233,6 +1233,7 @@ LINKLINKFILES= \ text$/schart$/02$/02020000.xhp \ text$/schart$/04$/01020000.xhp \ text$/schart$/main0000.xhp \ + text$/schart$/main0202.xhp \ text$/schart$/main0503.xhp \ diff --git a/helpcontent2/util/swriter/makefile.mk b/helpcontent2/util/swriter/makefile.mk index 8b41362846..b54a27fb0f 100644 --- a/helpcontent2/util/swriter/makefile.mk +++ b/helpcontent2/util/swriter/makefile.mk @@ -1389,6 +1389,7 @@ LINKLINKFILES= \ text$/schart$/02$/02020000.xhp \ text$/schart$/04$/01020000.xhp \ text$/schart$/main0000.xhp \ + text$/schart$/main0202.xhp \ text$/schart$/main0503.xhp \ -- cgit