Excel Forum

YTLE#81: Conditional Format CHART??

See how to add conditional formatting to a chart by creating a new column of data with a formula. See how to use the IF, SUM and NA functions to create the new column of data. Learn about the TEXT function for creating labels for charts.

See the chart tricks:
1) Change the chart type for only one data series amongst three data series
2) Add Data Series to Secondary Axis
3) Change the Overlap to a column data series

Got a Question? Ask it Here in the Forum.