Film, Media & TV0 min ago
Conditional Formatting In Excel Charts
5 Answers
Hi,
I am using Excel 2010 and want to create a chart with conditionally formatting that turns the chart background green when the data is above target and red when it is below.
There are only two lines of data in the chart.
Is this possible ?
I am using Excel 2010 and want to create a chart with conditionally formatting that turns the chart background green when the data is above target and red when it is below.
There are only two lines of data in the chart.
Is this possible ?
Answers
Best Answer
No best answer has yet been selected by andyGTBristol. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.There is also some useful instructions detailing how to use conditional formatting to change the back ground colour of a Chart:-
http:// chandoo .org/wp /2015/0 3/27/co ndition ally-fo rmat-ch art-bac kground s/
Basics are place chart in a fixed area of spreadsheet, e.g E3:L15, then use the Conditional Formating Options to create two new rules each which will change the Cells E3:L15 background colour based on a cell condition of the chart data cells e.g. Red if data cell A5>20, Green if A5
http://
Basics are place chart in a fixed area of spreadsheet, e.g E3:L15, then use the Conditional Formating Options to create two new rules each which will change the Cells E3:L15 background colour based on a cell condition of the chart data cells e.g. Red if data cell A5>20, Green if A5
Related Questions
Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.