Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
conditional formatting within chart
I've got a bar chart (the lines flow left to right) that i update every
week...the current bar chart i'm using has some sort of conditional formatting where if the number is 0, the bars are all green, but if the number is <0, then all the bars are red...for some reason my original chart's formatting stopped working. how do i set that up, short of highlighting each bar...i've got about 20 graphs to update... Thanks!!! JC |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
conditional formatting within chart
The way that I would do it is to have two sets of helper columns, one with
the negatives and one with the positives, like so =(IF(H1<0,ABS(H1),NA()) and =IF(H10,H1,NA()) and copy down. Then chart those two sets of data in one go. The bars will be setup as different colours and you can format to red and green. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "JC" wrote in message ... I've got a bar chart (the lines flow left to right) that i update every week...the current bar chart i'm using has some sort of conditional formatting where if the number is 0, the bars are all green, but if the number is <0, then all the bars are red...for some reason my original chart's formatting stopped working. how do i set that up, short of highlighting each bar...i've got about 20 graphs to update... Thanks!!! JC |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
conditional formatting within chart
Here's a tutorial that expands upon the technique Bob describes:
http://peltiertech.com/Excel/Charts/...nalChart1.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Bob Phillips" wrote in message ... The way that I would do it is to have two sets of helper columns, one with the negatives and one with the positives, like so =(IF(H1<0,ABS(H1),NA()) and =IF(H10,H1,NA()) and copy down. Then chart those two sets of data in one go. The bars will be setup as different colours and you can format to red and green. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "JC" wrote in message ... I've got a bar chart (the lines flow left to right) that i update every week...the current bar chart i'm using has some sort of conditional formatting where if the number is 0, the bars are all green, but if the number is <0, then all the bars are red...for some reason my original chart's formatting stopped working. how do i set that up, short of highlighting each bar...i've got about 20 graphs to update... Thanks!!! JC |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
conditional formatting within chart
Sheesh! And there was me thinking I thought it up :-)!
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Jon Peltier" wrote in message ... Here's a tutorial that expands upon the technique Bob describes: http://peltiertech.com/Excel/Charts/...nalChart1.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Bob Phillips" wrote in message ... The way that I would do it is to have two sets of helper columns, one with the negatives and one with the positives, like so =(IF(H1<0,ABS(H1),NA()) and =IF(H10,H1,NA()) and copy down. Then chart those two sets of data in one go. The bars will be setup as different colours and you can format to red and green. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "JC" wrote in message ... I've got a bar chart (the lines flow left to right) that i update every week...the current bar chart i'm using has some sort of conditional formatting where if the number is 0, the bars are all green, but if the number is <0, then all the bars are red...for some reason my original chart's formatting stopped working. how do i set that up, short of highlighting each bar...i've got about 20 graphs to update... Thanks!!! JC |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
conditional formatting within chart
Bob -
I didn't think of it either, but I sure don't remember who I copped it from. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Bob Phillips" wrote in message ... Sheesh! And there was me thinking I thought it up :-)! -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Jon Peltier" wrote in message ... Here's a tutorial that expands upon the technique Bob describes: http://peltiertech.com/Excel/Charts/...nalChart1.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Bob Phillips" wrote in message ... The way that I would do it is to have two sets of helper columns, one with the negatives and one with the positives, like so =(IF(H1<0,ABS(H1),NA()) and =IF(H10,H1,NA()) and copy down. Then chart those two sets of data in one go. The bars will be setup as different colours and you can format to red and green. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "JC" wrote in message ... I've got a bar chart (the lines flow left to right) that i update every week...the current bar chart i'm using has some sort of conditional formatting where if the number is 0, the bars are all green, but if the number is <0, then all the bars are red...for some reason my original chart's formatting stopped working. how do i set that up, short of highlighting each bar...i've got about 20 graphs to update... Thanks!!! JC |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart with conditional formatting | Charts and Charting in Excel | |||
Conditional Chart Formatting? | Charts and Charting in Excel | |||
Chart Conditional Formatting | Excel Discussion (Misc queries) | |||
Conditional formatting a bar chart | Charts and Charting in Excel | |||
Conditional formatting in a chart | Charts and Charting in Excel |