Stevo985 Posted August 16, 2013 Author VT Supporter Share Posted August 16, 2013 Wonder where they got the idea of the rear from...? 3 Link to comment Share on other sites More sharing options...
Genie Posted August 16, 2013 Share Posted August 16, 2013 Excel Question: Is there a way to link text to the colour of the bar in the chart it will create? i.e. If I have the word Green or Red in a cell next to some data for a graph, is it possible that the chart references the cell text to colour the bars individually? Link to comment Share on other sites More sharing options...
Anthony Posted August 16, 2013 VT Supporter Share Posted August 16, 2013 Yes. Conditional formatting is the phrase to search under. Link to comment Share on other sites More sharing options...
Shillzz Posted August 16, 2013 Share Posted August 16, 2013 For a graph? I don't think so. Though Anthony may know something (many things) that I don't. You could easily use conditional formatting to do whatever you wanted with an actual cell, but I don't think it can be applied to graphs. Link to comment Share on other sites More sharing options...
Stevo985 Posted August 16, 2013 Author VT Supporter Share Posted August 16, 2013 Yeah what Shillz said. Conditional formatting works for cells but I don't think it translates to graphs. Wouldn't surprise me if it was possible though. My rule of thumb for excel is "if you're asking whether it can do something, it probably can" Link to comment Share on other sites More sharing options...
Genie Posted August 16, 2013 Share Posted August 16, 2013 Yep, I use conditional formatting a lot for cell changes, not sure I can set something in a cell which will drive a certain coloured bar in a column chart? Link to comment Share on other sites More sharing options...
Popular Post AVFC_Hitz Posted August 16, 2013 Popular Post Share Posted August 16, 2013 God! Why are you using Excel?! You should be be using DingBat 2.0. You can print individual cell date on toilet paper in Jeff-dibble mode! God, MS Office. Ermagerd! 5 Link to comment Share on other sites More sharing options...
Stevo985 Posted August 16, 2013 Author VT Supporter Share Posted August 16, 2013 Yeah I'm waiting for a (serious) post like that. Link to comment Share on other sites More sharing options...
limpid Posted August 16, 2013 Administrator Share Posted August 16, 2013 Excel Question: Is there a way to link text to the colour of the bar in the chart it will create? i.e. If I have the word Green or Red in a cell next to some data for a graph, is it possible that the chart references the cell text to colour the bars individually? You might get a better response in the Tech room. Link to comment Share on other sites More sharing options...
snowychap Posted August 16, 2013 Share Posted August 16, 2013 (edited) Excel Question: Is there a way to link text to the colour of the bar in the chart it will create? i.e. If I have the word Green or Red in a cell next to some data for a graph, is it possible that the chart references the cell text to colour the bars individually? Is there a way of converting the text of a cell in to the RGB colour as I'd guess that's what you'd need in order to code the interior colour of the series (i.e. the bar) as the same colour as the text (e.g. gree, blue)? p.s. Simon's probably right. Edited August 16, 2013 by snowychap Link to comment Share on other sites More sharing options...
villaajax Posted August 17, 2013 Share Posted August 17, 2013 Garth Crooks completely failing to understand how a buy out clause works. "£1 more is a joke" "It activates the buyout clause" "...Well they should offer more" Why? 1 Link to comment Share on other sites More sharing options...
Genie Posted August 17, 2013 Share Posted August 17, 2013 It has made Arsenal look a bit silly though hasn't it, they should have offered £40.1m. The extra 100k is basically about 4 or 5 days of his wages. Link to comment Share on other sites More sharing options...
villa4europe Posted August 17, 2013 Share Posted August 17, 2013 just flicked the highlights on, when did v festival become a late night version of t4 on the beach? Link to comment Share on other sites More sharing options...
Meath_Villan Posted August 18, 2013 Share Posted August 18, 2013 sky remote just stop working when I was about to watch MOTD .....word removed ...anyway taking one battery out and pressing select for 60 seconds reset the remote Link to comment Share on other sites More sharing options...
Shillzz Posted August 19, 2013 Share Posted August 19, 2013 SNOWBOARDING British snowboarder Jenny Jones finishes second in the women's world cup slopestyle at the New Zealand winter games. American Jamie Anderson produced a flawless performance to win gold, while Cheryl Maas of the Netherlands took the bronze medal. Anderson scored 94.75 points on her first run and clinched the gold medal when none of her closest competitors could match her score on the second run. Would this be our very own Baselayers? Congratulations to her if it is. 2 Link to comment Share on other sites More sharing options...
Meath_Villan Posted August 19, 2013 Share Posted August 19, 2013 SNOWBOARDING British snowboarder Jenny Jones finishes second in the women's world cup slopestyle at the New Zealand winter games. American Jamie Anderson produced a flawless performance to win gold, while Cheryl Maas of the Netherlands took the bronze medal. Anderson scored 94.75 points on her first run and clinched the gold medal when none of her closest competitors could match her score on the second run. Would this be our very own Baselayers? Congratulations to her if it is. If shes not first ....shes last Link to comment Share on other sites More sharing options...
villarule123 Posted August 19, 2013 VT Supporter Share Posted August 19, 2013 I thought Baselayers was Ci? Link to comment Share on other sites More sharing options...
Ingram85 Posted August 19, 2013 Share Posted August 19, 2013 Over time I've come to realise it probably is more likely to be CI than the real Jenny Jones. 1 Link to comment Share on other sites More sharing options...
Shillzz Posted August 19, 2013 Share Posted August 19, 2013 That would be quite funny. Link to comment Share on other sites More sharing options...
villarule123 Posted August 19, 2013 VT Supporter Share Posted August 19, 2013 Maybe it's the original Scuba Steve getting his own back? 1 Link to comment Share on other sites More sharing options...
Recommended Posts