Archive for Monday, March 3rd, 2008
VBA Conditional Formatting of Charts by Series Name
by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.
I’ve got a couple of tutorial pages on my web site that deal with conditionally formatted charts. The trick is to set up ranges containing formulas for each of the conditions, so that if the condition for that range is met, the range contains the value to plot, otherwise it contains #N/A, which isn’t plotted [...]
Posted: Monday, March 3rd, 2008 under Example Charts, Formatting, VBA.
Comments: 19
VBA Conditional Formatting of Charts by Value
by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.
I’ve got a couple of tutorial pages on my web site that deal with conditionally formatted charts. The trick is to set up ranges containing formulas for each of the conditions, so that if the condition for that range is met, the range contains the value to plot, otherwise it contains #N/A, which isn’t plotted [...]
Posted: Monday, March 3rd, 2008 under Example Charts, Formatting, VBA.
Comments: none
VBA Conditional Formatting of Charts by Category Label
by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.
I’ve got a couple of tutorial pages on my web site that deal with conditionally formatted charts. The trick is to set up ranges containing formulas for each of the conditions, so that if the condition for that range is met, the range contains the value to plot, otherwise it contains #N/A, which isn’t plotted [...]
Posted: Monday, March 3rd, 2008 under Example Charts, Formatting, VBA.
Comments: 2
