Differential D18994 Diff 51707 doc/sheets/advanced.docbook

Changeset View

Standalone View

View Options

doc/sheets/advanced.docbook

Show First 20 Lines • Show All 413 Lines • ▼ Show 20 Line(s)
414chart size can easily be changed at any time. When you release the mouse 414​chart size can easily be changed at any time. When you release the mouse
415button a <guilabel>Chart Options</guilabel> dialog box will appear.</para> 415​button a <guilabel>Chart Options</guilabel> dialog box will appear.</para>
416<para>The data area is already prefilled with the selected cell range. 416​<para>The data area is already prefilled with the selected cell range.
417Select the first row and column as labels, check <guilabel>Data set in rows</guilabel> 417​Select the first row and column as labels, check <guilabel>Data set in rows</guilabel>
418and click the <guibutton>OK</guibutton> button. The Dialog will vanish and you 418​and click the <guibutton>OK</guibutton> button. The Dialog will vanish and you
419will see the chart embedded into the worksheet.</para> 419​will see the chart embedded into the worksheet.</para>
420<para>Now select <guibutton>Chart Editing Tool</guibutton> from the <guilabel>Tools</guilabel> 420​<para>Now select <guibutton>Chart Editing Tool</guibutton> from the <guilabel>Tools</guilabel>
421docker and edit the chart properties like chart type, labels and axis in the 421​docker and edit the chart properties like chart type, labels and axis in the
422<guilabel>Tools Options</guilabel>.</para> 422​<guilabel>Chart editing</guilabel>.</para>
423<para> 423​<para>
424<mediaobject> 424​<mediaobject>
425<imageobject> 425​<imageobject>
426<imagedata fileref="chart1.png" format="PNG"/> 426​<imagedata fileref="chart1.png" format="PNG"/>
427</imageobject> 427​</imageobject>
428<textobject> 428​<textobject>
429<phrase>Screenshot of embedded chart</phrase> 429​<phrase>Screenshot of embedded chart</phrase>
430</textobject> 430​</textobject>
Show All 11 Lines
442squares and select <guimenuitem>Delete</guimenuitem>.</para> 442​squares and select <guimenuitem>Delete</guimenuitem>.</para>
443<para>To move the chart move the cursor into the chart. 443​<para>To move the chart move the cursor into the chart.
444The cursor should then change to a cross, press the 444​The cursor should then change to a cross, press the
445<mousebutton>left</mousebutton> mouse button and you will be able to drag the 445​<mousebutton>left</mousebutton> mouse button and you will be able to drag the
446chart to where you want it to be.</para> 446​chart to where you want it to be.</para>
447<para>To restore the chart to its normal appearance simply click anywhere 447​<para>To restore the chart to its normal appearance simply click anywhere
448outside of the chart area.</para> 448​outside of the chart area.</para>
449<para>To change the format of the chart itself <mousebutton>left</mousebutton> 449​<para>To change the format of the chart itself <mousebutton>left</mousebutton>
450click twice within the chart area. The chart <guilabel>Tools Options</guilabel> 450​click twice within the chart area. The chart <guilabel>Chart editing</guilabel>
451should appear in the docker. You can then 451​should appear in the docker. You can then
452use these tools to change the chart.</para> 452​use these tools to change the chart.</para>
453</sect1> 453​</sect1>
454 454​
455<sect1 id="insertdata"> 455​<sect1 id="insertdata">
456<title>Inserting External Data</title> 456​<title>Inserting External Data</title>
457<para>You can insert data from a text file or from the clipboard into a 457​<para>You can insert data from a text file or from the clipboard into a
458worksheet by first selecting the cell where you want the top left item of the 458​worksheet by first selecting the cell where you want the top left item of the
▲ Show 20 Lines • Show All 436 Lines • Show Last 20 Lines