Conditional formating in graphs

  • Thread starter Thread starter Angel Agosto
  • Start date Start date
A

Angel Agosto

I would like to know if you can apply some conditional
formatting in a graph data label. An example is if a
variable X is below a determined value Z then in the
graph the data label for variable X is in red, but if X
= Z then the data label on the chart should be in black.
Click to expand...
Is this posible? I would appreciate any help you can
offer me.
 
This page has a couple examples showing how to format the individual points:

http://www.geocities.com/jonpeltier/Excel/Charts/format.html

What you might do is set up separate series, format the points the same,
but format the labels differently.

You can use a VBA approach to step through the labels, butt you will
have to rerun the macro if the data changes.

- Jon
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help graphing an equation 7
labeling data points in a scatter graph 2
Combining a 2-D column graph and a 2-D line graph on the same char 3
Conditional number format of x-axis based on value? 1
Creating a Line graph 6
Formatting in bar chart axis 1
print excel graph 1
How do I apply conditional formatting to axis labels? 1

Back
Top