If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
conditional formatting with data labels?
I have a bar chart with data labels set up that are linked to cells. I have
a bunch of charts to make, so linking to cells was the way to go.. The problem is, even though the linked cells contain conditional formatting to BOLD some of them, that bolding does not convey to the linked data labels. Specifically I am trying to make them bold if another cell (containing a significant p value) is not empty. This is what the conditional formatting does but I would like it to convey to the labels, if this is possible? Thanks. |
#2
|
|||
|
|||
Dave -
You could use VBA to detect changed values, and reformat the labels. But that sounds like an awful lot of work. I have another idea, analogous to my conditional charting technique: http://peltiertech.com/Excel/Charts/...nalChart1.html In this example I have multiple columns of data, which only contain a value if a certain condition is met. Each column is plotted in a differently formatted series, giving the impression that the points are changing if the conditions change. Make your chart with two series, one for each condition, and use data labels on each. One set of labels should be formatted bold. You can also format the series differently if you want, to signify the difference, or the same. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Dave R. wrote: I have a bar chart with data labels set up that are linked to cells. I have a bunch of charts to make, so linking to cells was the way to go.. The problem is, even though the linked cells contain conditional formatting to BOLD some of them, that bolding does not convey to the linked data labels. Specifically I am trying to make them bold if another cell (containing a significant p value) is not empty. This is what the conditional formatting does but I would like it to convey to the labels, if this is possible? Thanks. |
#3
|
|||
|
|||
Jon - good thinking! I'll give it a shot.
"Jon Peltier" wrote in message ... Dave - You could use VBA to detect changed values, and reformat the labels. But that sounds like an awful lot of work. I have another idea, analogous to my conditional charting technique: http://peltiertech.com/Excel/Charts/...nalChart1.html In this example I have multiple columns of data, which only contain a value if a certain condition is met. Each column is plotted in a differently formatted series, giving the impression that the points are changing if the conditions change. Make your chart with two series, one for each condition, and use data labels on each. One set of labels should be formatted bold. You can also format the series differently if you want, to signify the difference, or the same. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Dave R. wrote: I have a bar chart with data labels set up that are linked to cells. I have a bunch of charts to make, so linking to cells was the way to go.. The problem is, even though the linked cells contain conditional formatting to BOLD some of them, that bolding does not convey to the linked data labels. Specifically I am trying to make them bold if another cell (containing a significant p value) is not empty. This is what the conditional formatting does but I would like it to convey to the labels, if this is possible? Thanks. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Disappearing Data Labels | Erin | General Discussion | 2 | August 25th, 2004 05:08 PM |
data labels not linked to data source | viveleroi0 | Charts and Charting | 8 | August 19th, 2004 02:12 AM |
Carry over conditional formatting | Justin | Mailmerge | 3 | May 22nd, 2004 10:41 AM |
Conditional Formatting Questions | Andy B | Worksheet Functions | 1 | May 12th, 2004 02:48 PM |
MIN value exclude '0' & Conditional Formatting | JEM | Worksheet Functions | 5 | April 16th, 2004 03:40 AM |