Dot Chart in Excel - Excel Tips and Tricks Learn how to create dot plot chart in Excel. Insert Chart 1) Select dataset 2) Alt F1 3) Resize and reposition Change Chart Type 1) Chart type 2) Combo 3) Max Qty to "Cluster bar" 4) Min Qty to "Stacked bar" 5) Variance to "Stacked bar" 6) Only Max Qty with "Secondary Axis" checked. 7) OK Swap Axes 1) Add Chart Element ~ Axes ~ Secondary Vertical 2) Select on Primary Y-Axis 3) Ctrl 1 4) Category in reverse order 5) Click on Secondary Vertical (Category)

Top 100 Excel Tips and Tricks to Make You Productive in 2026