Now is a simple job of applying labels and formatting as applicable
#Openoffice conditional formatting chart series#
I have chosen a Line ChartĮxcel will draw a Chart with 3 series of lines Now goto the Insert, Chart tab and select the chart type you want to use. Select the Range B3:E18, note it includes the X Axis Labels and Headers Goto the Data, Data Validation Tab and select Data Validation I have used values A to P as X Axis Labels and used a formula =Randbetween(10,20) in column C for the Y Values for the chart These data series do not have to be visible but they can, at the same time, have Data Labels or other formatting applied. The concept applied here to achieve the final result that Greg wants is that charts can use multiple data series.
#Openoffice conditional formatting chart download#
This post will describe how this is achieved as well as extend the idea into the fourth dimension.Īll the charts in this post are available in the sample file: Download Sample File. There are many more ways that you can use it as you get creative with your custom formulas.This week in the Forums, Greg asked the question, “ I would like to conditionally format the data labels position to be above the plot line in a scatter plot if a certain cell contains ‘True’ and below the plot line if that cell contains ‘False’.” In this resource, I have covered formatting based on the values of another cell, whether that cell contains a numeric or text value.
![openoffice conditional formatting chart openoffice conditional formatting chart](https://www.linuxtopia.org/online_books/office_guides/microsoft_office_to_openoffice_migration/0602MG-SharingFilesWithMSOUsers_html_m475b91d9.gif)
When you start to use custom formulas with conditional formatting a lot of possibilities open up for what you can do with the formatting in your spreadsheet. The key is setting up the appropriate custom formula in the conditional formatting rules.Īfter I have set up the formula and applied it to the appropriate range, this is how it will look in my spreadsheet: To do this, the steps are the same as in the previous example. In this example, I will be highlighting the students’ name in Column A, if the text in Column C is equal to “Fail’ In the previous example, I showed changing the color of one cell based on the value of another cell, but we can also use the same process to change the formatting of a cell based on text in another cell. You will now see that the cells that have met the custom rule you set up will have highlighted with the color you have chosenĬonditional Formatting Based on Text in Another Cell
![openoffice conditional formatting chart openoffice conditional formatting chart](https://i.stack.imgur.com/Iofb1.png)
Select the green Done button when you are finishedĨ. I have chosen a green color in this example. Select the Fill color option under Formatting styleħ. Next we will need to select the color that our cells that meet this rule will change to. In this example, I want to highlight the cells in column A, if the corresponding cell in column B is greater than 2000.
![openoffice conditional formatting chart openoffice conditional formatting chart](https://i.ytimg.com/vi/kkHEdUI7cfQ/maxresdefault.jpg)
In the text box, we will be entering our formula. Navigate down to the Format rules area and click on the drop-down box to chang the Format cell is ruleĥ. Next in the top menu select Format>Condtional formattingģ. The first step is to select the cell range that you want to highlightĢ. So basically what I am doing is creating a formula that will highlight a cell based on the value of another cell.ġ. I am going to set up a custom formula in conditional formatting that will highlight the month in column A, if the revenue for that month in column B is greater than 2000. In this example, I have a month in column A and revenue for that month in column B. The trick to changing the formatting of a cell based on another cell is to use the Custom formula is option in the conditional format rules.