OPENOFFICE CALC GRAPH DOWNLOAD AND USE

Openoffice Calc Graph Download And Use

OpenOffice Calc offers pretty much most of the functionalities that are in Microsoft Excel. On Windows, instead of spending money on Microsoft Office, download and use Openoffice. On Ubuntu, OpenOffice is the default office suite. OpenOffice works on both Linux and Windows.

Spreadsheet programs typicallyAssume that the column on the left is the variable that is plotted on theHorizontal (x) axis of the chart, and the column on the right is the variableThat is plotted on the vertical (y) axis. The order of the columns matters. (The 'B2' cell contents change from the formula '=SIN(A2)'Into a '0'.) Drag-copy the formula all the way down to the 90 in the A column.Don't worry if you don't know what the numbers mean we aren't concernedWith that. Click on the bottom right corner of the B2 cell. (Ctrl+up arrow is a quick way to move up.) Go back to the top and Select B2.

Select Lines Only and check the X axis and Y axis grid line boxes. (Hold the cursor over the icons to find it.) Select -New Sheet- from the drop-down box labeled Chart results in worksheet.Select XY Chart. The 'AutoFormat Chart' window appears.) Click anywhere on the spreadsheet.

(Probably labeled Sheet4.) Look at the worksheet tabs at the bottom. Type X for X axis title, and Sine(x) for Y axis title. Click the X axis and Y axis check boxes. Don't uncheck it.)Give the chart a title, My First Chart, in the box that has Main Title in it.

In the dialog box below Fill, click the and select None. That's better, but it could still use some improvement. Select Cubic Spline, , from the Variants box at the bottom. That is appropriate forSome data, but the sine function is a smooth function, so make the followingDouble-click somewhere on the chart if you see green boxes or no boxes. Appearance Of ChartCharts created by spreadsheet programs are unappealing most of the time.You have to mess with the format of the chart elements to make them lookThe first thing I notice is a jagged plot line.

(You have to scroll down the palette.) Click OK. Change the Color to Gray 40%. (Click the repeatedly or highlight the number in the dialog box and type ”.02”.)Select F ormat > Grid > All Axis Grids. In the Width dialog box, change the width to. In the Colo r dialog box, change the color to Sea Blue.

Click F ormat > Sheet > Rename. Click on a worksheet cell. When you are done, click somewhere else on the chart to accept the changes. Change the main title text to Sine Function by double-clicking on it and editing it. Clear the Maximum check box and replace 90 with 45. Select Format > Axis > X Axis.

To get good at it,You'll have to experiment with the settings and develop your own style.Tutorials are improved by input from users. The point is that youCan change every aspect of the chart in some fashion. (Click “ File > Save”.) SummaryYou just used most of the chart editing commands.