![]() I’m not sure why Writer decided to spontaneously change my chart colors this way, but if any oo programmers happen to be reading, this might be a good thing to fix in the next release. The key is to single-click and/or double-click at the right time and place if you don’t, you won’t be able to get to the correct “Data Point” dialog box. Repeat steps 4-6 for each pie slice and you’re done. Select the color you want the pie slice to have and click Save.Select the “Area” tab and select “Color” in the dropdown box. Double-click on this same “selected” pie slice this will bring up the “Data Point” dialog box.Single click on one of the pie slices this will select that one pie slice.Single-click on the pie this will make a series of small green squares appear on your pie slices, one green square per pie slice.Double-click the chart to put it in “Editing mode.”. ![]() After pasting your chart into Writer, single-click the chart to make sure it’s selected.I figured I would just manually set the proper color for each pie slice, but it’s not at all obvious how to do this simple task, and the oo help documentation isn’t that helpful. Unfortunately, when I copied and pasted the charts into Writer, Writer changed the colors! Wha? The current date should appear in cell C4. Enter TODAY ( ) Press the ENTER key on the keyboard. In this tutorial, we will use the TODAY function. Built into Open Office Calc are a number of DATE functions that can be used to do this. I didn’t figure this would be a huge problem, especially since when I created the charts in Calc, it gave the corresponding categories the same colors without me having to do anything. Exponential and Logarithmic Functions The material on natural logs and exponentials in Calc II is similar to Calc I and includes knowledge of graphs. It is normal to add the date to a spreadsheet. Recently I created two pie charts from similar data and I needed the colors of the pie slices to be the same for corresponding categories in each chart in other words, I had a Category A in Chart 1 and a Category A in Chart 2, and I wanted the pie chart slices for Category A to be the same color of blue in both Chart 1 and Chart 2. Typically, I’ll create a pie or bar chart in Calc, then copy and paste it into Writer (oo’s version of MS Word). ![]() You could also set up a comparable Gantt chart within the spreadsheet without the Chart Wizard, but it would probably take somewhat longer to format the cells.As a frequent user of the OpenOffice apps, including the Calc spreadsheet (oo’s version of Excel), I occasionally need to create a chart from some of my data. So that’s how you can set up a Gantt chart with OpenOffice’s chart tools. Then select the Area tab and alternative colors for the bars as below. To customize the colors of each of the bars on the chart, click the left mouse button twice, right-click and select Object Properties. You can remove the legend from the chart by selecting it and pressing the Delete button. The X axis can show you the overall project duration in days, weeks or longer. The bars in that chart show you how long each step of the project should take. Then you’ll have a Gantt chart as in the shot below. There select None to remove the blue from the chart, and click OK to close the window. Then right-click and select Object Properties to open the window in the shot below.Ĭlick on the Area tab and select the Color drop-down list. Left-click on one of the blue areas on the bars to select them. Next, remove the blue colors from the bars. Then you’ll have a chart similar to the one below with blue and red bars. Click Bar, the Stacked graph thumbnail and Finish to close the wizard. Click the Chart button at the top of the window to open the Chart Wizard window. Next, select all the cells within your table except the column headings. Then enter the week, or day, numbers you expect to start each step, and how long each step of the project should take in a period of days/weeks as in the shot below. For example, enter the final step of the project in the highest row of the column and the first step at the bottom. Enter each step of the project in the Project Step column in backward order. Open OpenOffice Calc, and enter the following column headings: Project Step, Start and Length. You can quickly set up a Gantt chart with the OpenOffice spreadsheet application. The Gantt charts show the expected start and finish times of each stage of a project. Creating a chart Creating a chart You can create graphic charts in two ways while using : From the main menu: Insert > Object > Chart. A Gantt chart is a project planning tool that illustrates a project’s duration.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |