Reorder all Conditional Formatting rules into a new order of execution.
"Monthy_Billing" Worksheet
Top Rule (Bold and Underline)
Second Rule (Red text)
Third Rule (Pink Fill)
Fourth Rule (Red Text with Strikethrough)
Create a combo chart.
Cell range B4:I299 on "Montly_Billing" worksheet
Horizontal axis label range: "Date" (column D)
First data series range: All cells in "Duration" (column H) with a value of "Straatsma" in name (column C)
Second data series range: All cells in "Charge" (column I) with a value of "Straatsma" in name (column C)
Type: Combo Chart
"Duration" series: Clustered Column (Primary Axis)
"Charge" series: Line (Secondary Axis)
New Worksheet "Straatsma_Chart"
Primary Axis Bounds:
Minimum ("0.0")
Maximum ("8.0")
Secondary Axis Bounds:
Minimum ("2000.0")
Maximum ("4000.0")
Insert a trendline for a series.
Combo chart
"Duration" series Linear