What are the Best Graphs for Comparing Two Sets of Data?

ExcelTips247 on Instagram: "Create a grouped bar chart in Excel - Excel Tips and Tricks Learn how to create a group bar chart in Excel. Here are the steps I'll name my video. Max Value in Data Set =MAX(C8:C12,E8:E12,G8:G12,I8:I12)*1.14 Difference Between Max and Cell Value =$B$5-C7 Insert Chart 1) Ctrl+A 2) Insert ~ 2-D Stacked Bar Chart 3) Resize and Reposition 4) Chart Design ~ Switch Row/Column 5) Fill helper column as white 6) Delete vertical grid lines 7) Delete helper legend 8) Delete x-ax

ExcelTips247 on Instagram: "Conditional Bar Chart - Excel Tips and Tricks Learn how to create conditional bar chart. We are essentially coloring a bar based on value in Excel. Here, the steps outline in my video. Marks Less Than 50 =IF(C7 =$D$4,C5 =86 =IF(C5>=F4,C5,"") Draw Bar Chart 1) Select Dataset (exclude headers) 2) Alt+F1 3) Chart Design ~ Change Chart Type 4) Bar 5) OK 6) Resize and repositions 7) Exclude "Mark" column Color Assignment 1) Select gray bar chart series 2) Ctrl+1 3) Fill= G