Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Bar Graph
I have a bar graph and woulld like to have one of the bars change colour depending on the value of a cell (1 - Green, 2 - Orange, 3 - Red). I dont have a lot of experiance when it comes to coding graphs. Please can you help, -- ceemo ------------------------------------------------------------------------ ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650 View this thread: http://www.excelforum.com/showthread...hreadid=551156 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Bar Graph
Hi,
No need for code if you use some worksheet formula and multiple series. http://peltiertech.com/Excel/Charts/...nalChart1.html Cheers Andy ceemo wrote: I have a bar graph and woulld like to have one of the bars change colour depending on the value of a cell (1 - Green, 2 - Orange, 3 - Red). I dont have a lot of experiance when it comes to coding graphs. Please can you help, -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Bar Graph
make a so-called conditional chart. This can be automated by making columns
of yr data for each colour you want (in yr example 3 columns), and putting an if-statement that writes the value if the condition is right for the colour or #NA() if the value falls outside the conditions. Make sure that the value always is displayed in one of the three columns. Plot the cells with the IF-statements as three different series. HTH, Henk "ceemo" wrote: I have a bar graph and woulld like to have one of the bars change colour depending on the value of a cell (1 - Green, 2 - Orange, 3 - Red). I dont have a lot of experiance when it comes to coding graphs. Please can you help, -- ceemo ------------------------------------------------------------------------ ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650 View this thread: http://www.excelforum.com/showthread...hreadid=551156 |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Bar Graph
wow the link (above) is really handy but i cant work out where the colours have been linkes to the criteria ? Anyone know? -- ceemo ------------------------------------------------------------------------ ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650 View this thread: http://www.excelforum.com/showthread...hreadid=551156 |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Bar Graph
If I understand your question the actual colour of each bar series would
have to be set manually. ceemo wrote: wow the link (above) is really handy but i cant work out where the colours have been linkes to the criteria ? Anyone know? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
Bar Graph
hmm but when i change the value of the random values the cell colour automatically changes? How is this possible if the colours havent been predifined for each criteria range? -- ceemo ------------------------------------------------------------------------ ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650 View this thread: http://www.excelforum.com/showthread...hreadid=551156 |
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
Bar Graph
the cell colours change?? Are you talking about conditional formatting
of cells now rather than the chart columns? ceemo wrote: hmm but when i change the value of the random values the cell colour automatically changes? How is this possible if the colours havent been predifined for each criteria range? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#8
Posted to microsoft.public.excel.charting
|
|||
|
|||
Bar Graph
Yes thats right i would like to know more about the conditional formatting of charts. I have a chart with two bars and i would like the second bar to change to red, orange or green depending on the value of a cell ceemo 'I have a bar graph and woulld like to have one of the bars change colour depending on the value of a cell (1 - Green, 2 - Orange, 3 - Red). I dont have a lot of experiance when it comes to coding graphs.' -- ceemo ------------------------------------------------------------------------ ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650 View this thread: http://www.excelforum.com/showthread...hreadid=551156 |
#9
Posted to microsoft.public.excel.charting
|
|||
|
|||
Bar Graph
Sorry I'm really confused now.
The link I posted demonstrates how to set up formula in cells to react to the original chart data. You then create a chart with these multiple data series. Of course you will need to manually set the colour of each series in the chart. But once set up any edits to the original chart data will automatically be updated within the chart. Try another explanation, this time by Ed Ferrero, Conditional Chart Formatting. http://www.edferrero.com/charting.aspx Cheers Andy ceemo wrote: Yes thats right i would like to know more about the conditional formatting of charts. I have a chart with two bars and i would like the second bar to change to red, orange or green depending on the value of a cell ceemo 'I have a bar graph and woulld like to have one of the bars change colour depending on the value of a cell (1 - Green, 2 - Orange, 3 - Red). I dont have a lot of experiance when it comes to coding graphs.' -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Bar graph and line graph overlayed | Charts and Charting in Excel | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Hyperlinkage of one graph with another graph or Drill down graph | Charts and Charting in Excel | |||
How do I create a combination graph with stackedColumns+lineGraph | Charts and Charting in Excel | |||
Line Graph Data Recognition | Charts and Charting in Excel |