Formatting a Chart Based On What Values Are Displayed

  • Thread starter Thread starter nouveauricheinvestments
  • Start date Start date
N

nouveauricheinvestments

Hi,

I have a chart and I would like to format the line so that if it is
below a certain value, the line is red. Is there any way to do this?
I'm pretty good with charting in excel.
 
I do this by creating a new series for each "condition" you want to display.
Let's say you want to format points that are less than 100 as red, do
something like this

=if(A1<100,A1,NA())

The NA() values will not be displayed on the chart. Create a series for
each color you want to display.
 
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

Excel 2010. How to copy chart format to all charts in sheet 2
Excel chart, set a vertical baseline on a certain date 0
Excel Changing chart label colors based on a value in a cell 0
create chart with column axis 10
Paste Excel Chart into Existing Powerpoint Chart 1
HIDE VALUE 0 FROM CHART 1
Word On a bar chart I want to have just one horizontal line, crossing the y axis at a value I determine. 1
Is there a way to draw a vertical line from a point on the chart line to the bottom of the chart 7

Back
Top