Forum Discussion
Help for beginner - Assigning text to certain values
Then, a column was added where the block was filled with either 'normal year' or 'dry year' with a yellow highlight. Does anyone know how to add such a column?
That would be a simple IF statement
= IF( temperature > x, "Text", "Alternative text")
The yellow would be a Conditional Format, either repeating the criterion
= temperature > x
or testing the content of the cell for the desired text.
2) A second y-axis was added with data from another excel sheet (temperature), and was wondering if someone could tell me how that was done.
That is done by changing the chart type for the temperature series to 'line', so generating a combination chart and selecting the secondary axis.
Then, a column was added where the block was filled with either 'normal year' or 'dry year' with a yellow highlight. Does anyone know how to add such a column?
That would be a simple IF statement
= IF( temperature > x, "Text", "Alternative text")
The yellow would be a Conditional Format, either repeating the criterion
= temperature > x
or testing the content of the cell for the desired text.
2) A second y-axis was added with data from another excel sheet (temperature), and was wondering if someone could tell me how that was done.
That is done by changing the chart type for the temperature series to 'line', so generating a combination chart and selecting the secondary axis.
