Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

In my spreadsheet I am collecting time periods when certain values have been changed. The user is restricted to 4 time periods. I would like to show the data based on thos time periods.

I've included a mock up' of the data and the type of graph I would like to create. I've tried to create it for the last hour but am obviously missing something so thought I'd ask around.

alt text

share|improve this question
    
Do you have to generate a graph, or could you do what you want through conditional formatting in the cells of the spreadsheet? –  Amos Jun 15 '10 at 9:20
    
A graph would have been my first choice but I'm going to be looking at CF - see comments below. –  RocketGoal Jun 15 '10 at 11:11

1 Answer 1

up vote 1 down vote accepted

You should use conditional formatting. One rule per colored column.

  • Use "Use a formula to determine which cells to format"
  • When the cell value is 1, make the font color red and the fill color red (1st column)
  • Use normal cell formatting options to make the font color white - the conditional formatting will override this.

You've probably already tried something similar to this - maybe you could elaborate on where it is failing for you. I got the best results by applying the conditional formatting to the first row in a column, then removing the absolute cell reference and then using the Format Painter to copy the conditional format to the other cells in the column.

share|improve this answer
    
I hadn't even thoguht about CF, so thanks for bringing up the idea. I'll give it a go. –  RocketGoal Jun 15 '10 at 11:10
    
Worked fine. Maybe there is another 'graph way of doing this but the CF version gave me what I was looking for. Thanks –  RocketGoal Jun 16 '10 at 14:49

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.