Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Excel graphing Question

  • 31-07-2009 9:13pm
    #1
    littlewopper
    Closed Accounts Posts: 39 ✭


    Hello all,

    I am currently [FONT=&quot]managing[/FONT] lots of data through excel.

    All results are graphed.

    In order to graph the information using bar charts, I would like to be able to enter a number to a cell..(1 or 2 etc) and after the number entry the cell will change colour to either blue or yellow, depending on number entry. This cell colour will then be the same colour on the bar chart.

    Can any body help.?????:eek:


Comments

  • #2
    Kevster
    Closed Accounts Posts: 2,980 ✭✭✭Kevster


    Hmm, to change the cell background depending on the numerical value, just use the 'Conditional Formatting' option in the Format menu-bar. I think that the rest is self-explanatory then. To change the background, click on 'Format' on the subsequent dialogue box that appears, go to the 'Patterns' tab, and then choose your desired colour (which should match that used in the bar chart).

    Kevin


  • #3
    littlewopper
    Closed Accounts Posts: 39 ✭littlewopper


    cheers kev..... thats it. thanks


Advertisement