DriversCrashes, No Sound, or Screen Glitches?PerformanceWindows Errors? Fix Them Before They SpreadDriversOutdated Drivers Are Slowing You Down
Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.
iTechGuides is reader-supported. When you buy through links on our site, we may earn an affiliate commission. As an Amazon Associate I earn from qualifying purchases. Learn more
Start with the question: what should your data help someone notice? Choose a chart or visual that makes that answer easy to see—whether it is a trend, a ranking, a relationship, or a geographic pattern. Here are 10 ways to visualize data in Excel, with the data shape each suits and a design caution for each.
How do I choose the right Excel visualization?
Match the visual to the job: use bars to compare categories, lines to follow change over evenly spaced time points, scatter plots to inspect relationships, histograms to examine distributions, and maps to compare regions. A waterfall explains how changes build to a total; a PivotChart helps readers explore summarized data interactively.
Before choosing a chart, arrange the data for the chart family. Microsoft’s guidance says column, bar, line, area, surface, and radar charts can use data in rows or columns. A pie chart expects one value series and labels; a scatter plot uses x and y values, while a bubble chart adds a third value for size. See Microsoft’s chart-type and data-layout guidance.
Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.
Excel’s Recommended Charts can suggest chart types based on selected data. Treat the recommendation as a starting point: confirm it answers the question, then add a descriptive title, axis titles, or labels where they help. Exact availability and ribbon steps vary by Excel release and platform. Microsoft documents filled maps for Microsoft 365 on Windows, Mac, and web, and says dynamic charts were introduced in Office 2024 and are also available in Microsoft 365; check the chart reference for your edition: available chart types in Office.
#1 Best Overall
Elebase USB to USB C Adapter for iPhone 18 Pro Max,USBC Car Charger Adapter
- Read Before You Buy — No Video Output: These adapters support charging and USB 2.0 data transfer, but cannot transmit video signals. Except for standard USB webcams (which use USB data only), they are not compatible with HDMI/DisplayPort cables, video-capable USB-C hubs, or docking stations with video output.
- Convert USB-A Ports to USB-C: Designed to connect USB-C earphones, cables, flash drives, card readers, and other USB-C accessories to standard USB-A ports. Plug-and-play with no drivers or software required.
- Aluminum Alloy Housing: Built with a sturdy aluminum alloy shell that aids in heat dissipation and protects against daily wear and scratches. Designed to maintain a stable and secure connection.
- Compact & Travel-Friendly: The ultra-compact design allows the adapter to stay plugged into your device without blocking adjacent ports or adding bulk, reducing wear and tear on your original USB ports.
- 12-Month Warranty: Backed by a 12-month manufacturer warranty for peace of mind. Designed to meet strict quality control standards for reliable everyday performance.
10 creative ways to show data in Excel
1. Add sparklines for compact row-by-row trends
- Question: Which rows are rising, falling, or fluctuating?
- Data shape: Many short series with the same context, such as monthly values for each product.
- Excel feature: In-cell line, column, or win/loss sparklines placed beside the table rows.
- Design caution: A sparkline is a quick visual cue, not a substitute for shared axes and detailed comparison. Confirm the Sparkline ribbon steps for your Excel edition.
2. Turn a matrix into a color-scale heat map
- Question: Where are the relative highs and lows across two dimensions?
- Data shape: A grid such as products by months, with a comparable numeric value in each cell.
- Excel feature: Conditional Formatting color scales applied to the matrix.
- Design caution: Do not make color the only way to distinguish values. Keep row and column labels visible and consider displaying the numbers as well.
3. Rank categories with sorted horizontal bars
- Question: Which categories have the largest or smallest values?
- Data shape: One value per category; horizontal bars are especially useful when category names are long.
- Excel feature: A bar chart, sorted in an order that supports the comparison.
- Design caution: Preserve a common zero baseline. Avoid sorting alphabetically if the point is to show rank.
4. Follow evenly spaced time points with a line chart
- Question: How does a value change over time?
- Data shape: Monthly, quarterly, or yearly observations at equal intervals.
- Excel feature: A line chart.
- Design caution: If dates are irregular, equally spaced category positions may imply a regular cadence that the data does not have.
5. Examine two measures with a scatter plot
- Question: Do two numeric measures move together, cluster, or produce outliers?
- Data shape: One numeric x value and one numeric y value for each observation, arranged in adjacent columns.
- Excel feature: An XY scatter chart.
- Design caution: A visible association does not establish that one measure causes the other.
6. Combine volume and rate in a combo chart
- Question: How does a count or volume relate to a rate or average across the same categories or periods?
- Data shape: Two measures with different visual roles, such as sales volume and conversion rate.
- Excel feature: A column-and-line combo chart; a secondary axis can be used when scales differ. Microsoft documents this combination in its chart-type reference.
- Design caution: Label both axes clearly and make the secondary scale obvious. Different scales can make the series appear more closely related than they are.
7. Use a waterfall to explain a change bridge
- Question: Which positive and negative steps turn a starting value into an ending total?
- Data shape: A starting figure, a sequence of increases and decreases, and an ending figure, with subtotals where needed.
- Excel feature: A waterfall chart. Mark subtotal and total columns as totals so they begin at zero; Microsoft documents the workflow in its available chart types guide.
- Design caution: Retain connectors when they help readers follow the running total from one step to the next.
8. Show a distribution with a histogram or concentration with a Pareto chart
- Question: How are numeric observations distributed, or which categories account for the largest share?
- Data shape: A list of numeric observations for a histogram; category values for a Pareto chart.
- Excel feature: A histogram groups observations into frequency bins. A Pareto chart orders categories from largest to smallest and overlays cumulative percentage.
- Design caution: Explain the histogram binning or the basis for the Pareto categories so the pattern can be interpreted. Microsoft describes both in its chart-type reference.
9. Compare geographic values with a filled map
- Question: How do values or categories differ among regions?
- Data shape: Geographic locations such as countries, states, counties, or postal codes, paired with a value or category.
- Excel feature: A filled map. Microsoft says this chart type is available in Microsoft 365 on Windows, Mac, and the web; details are in its available chart types guide.
- Design caution: Excel must recognize the location names. Confirm the geographic match and the reader’s version before relying on a specific map result. Use a map only when geography is meaningful to the question.
10. Make a summary interactive with a PivotChart
- Question: How can readers filter a summarized view by fields such as product, region, or date?
- Data shape: Clean, list-style source data with column headers, consistent data types, and no blank rows or columns in the range.
- Excel feature: A PivotChart based on PivotTable data; slicers can provide convenient filtering. An Excel Table can be a useful source because refreshed data can include new and updated table records. See Microsoft’s PivotChart guidance.
- Design caution: PivotCharts have chart-type limits. Microsoft’s overview excludes scatter, stock, and bubble charts; its Excel for Mac documentation also says treemap, statistical, and combo charts do not work with PivotTables in that workflow. Check the restrictions for your platform in the PivotChart documentation.
Which Excel chart should I use?
| What you want readers to notice | Try | Best-fitting input |
|---|---|---|
| Differences or rank across categories | Sorted bar or column chart | Categories with comparable values |
| Change over time | Line chart | Time points at equal intervals |
| Association between measures | Scatter plot | Paired numeric x and y values |
| How steps produce a total | Waterfall chart | Starting total, increases and decreases, ending total |
| Frequency or category concentration | Histogram or Pareto chart | Numeric observations or category values |
| Variation by region | Filled map | Recognizable geographic locations and values or categories |
| Filtering a summarized view | PivotChart | Clean tabular source data connected to a PivotTable |
Use sparklines or a heat map when the comparison belongs inside a table. Choose a combo chart when two measures need different visual roles, and use a map only when location is central to the analysis. Whichever format you choose, make the title and labels tell readers what they are seeing without asking them to guess.
Quick Recap
Bestseller No. 5
Best Value
Anker USB C Hub, 5-in-1 USBC to HDMI Splitter with 4K Display
- 5-in-1 Connectivity: Equipped with a 4K HDMI port, a 5 Gbps USB-C data port, two 5 Gbps USB-A ports, and a USB C 100W PD-IN port. Note: The USB C 100W PD-IN port supports only charging and does not support data transfer devices such as headphones or speakers.
- Powerful Pass-Through Charging: Supports up to 85W pass-through charging so you can power up your laptop while you use the hub. Note: Pass-through charging requires a charger (not included). Note: To achieve full power for iPad, we recommend using a 45W wall charger.
- Transfer Files in Seconds: Move files to and from your laptop at speeds of up to 5 Gbps via the USB-C and USB-A data ports. Note: The USB C 5Gbps Data port does not support video output.
- HD Display: Connect to the HDMI port to stream or mirror content to an external monitor in resolutions of up to 4K@30Hz. Note: The USB-C ports do not support video output.
- What You Get: Anker 332 USB-C Hub (5-in-1), welcome guide, our worry-free 18-month warranty, and friendly customer service.
Rank #4
Sale
UGREEN USB to USB C Adapter Combo 4-Pack, 10Gbps USB C Converter Space Gray
- Dual Converters, Infinite Potential：Includes 2× USB C male to USB A female adapters and 2× USB A male to USB C female adapters. Perfect for a wide range of uses—tablets with Bluetooth keyboards, expand USB ports on macbook, and more. Two different converters for all your daily needs
- Next-Level 10Gbps & 3A Charging: No more slow 480Mbps, this usb to usb c adapter has a transfer speed of up to 10Gbps, allowing you to do more transferring in less time. This usb adapter fits both USB A and USB C charger, supporting up to 3A fast charging
- Upgraded Exquisite Craftsmanship: With an aluminum alloy housing and metal connector, the usbc to usb adapter is extremely durable and sturdy. Rigorously tested to withstand more than 10,000 times of plugging and unplugging, ensuring long-lasting performance
- Broad Compatible: The usb c to usb adapter widely supports all USB C/ USB A devices like laptops, tablets, cellphones, car chargers, and phone chargers. Such as compatible with MacBook Pro/Air 2023/2022, Thunderbolt 4/3 Devices,Apple MagSafe Watch 9/8/7/SE/Ultra, iPad Pro 2022/2021, Samsung Galaxy S23/S20/S10, and iPhone 17/16/15 Pro. Plug and play
- Please Note: To reach 10Gbps speed, keep the cable under 3.3 ft. For USB A Male to USB C adapters, try flipping the USB C connector. USB C Male to USB A adapters support bidirectional 10Gbps transfer within 3.3 ft
Rank #3
Anker USB C Hub, 7in1 Multi-Port USB Adapter, 4K@60Hz USBC to HDMI Splitter
- Sleek 7-in-1 USB-C Hub: Features an HDMI port, two USB-A 3.0 ports, and a USB-C data port, each providing 5Gbps transfer speeds. It also includes a USB-C PD input port for charging up to 100W and dual SD and TF card slots, all in a compact design.
- Flawless 4K@60Hz Video with HDMI: Delivers exceptional clarity and smoothness with its 4K@60Hz HDMI port, making it ideal for high-definition presentations and entertainment. (Note: Only the HDMI port supports video projection; the USB-C port is for data transfer only.)
- Double Up on Efficiency: The two USB-A 3.0 ports and a USB-C port support a fast 5Gbps data rate, significantly boosting your transfer speeds and improving productivity.
- Fast and Reliable 85W Charging: Offers high-capacity, speedy charging for laptops up to 85W, so you spend less time tethered to an outlet and more time being productive.
- What You Get: Anker USB-C Hub (7-in-1), welcome guide, 18-month warranty, and our friendly customer service.
Rank #2
Anker USB-C Hub, 5-in-1 USB Hub for Laptops, 4K HDMI Multiport Adapter
- 5-in-1 USB-C Hub: Experience comprehensive connectivity featuring a Power Delivery input, two USB-A 2.0 ports, a USB-A 3.0 port, and an HDMI port. (Note: The USB-C power delivery input port is only for connecting an external wall charger to power your laptop and cannot power peripheral devices.)
- 90W Pass-Through Charging: Achieve optimal charging with 90W pass-through power to your laptop, supported by a total input of 100W, with the hub reserving 10W for operational efficiency. (Note: Wall charger not included.)
- Quick Data Transfers: Accelerate your productivity with rapid data transfers using a high-speed 5Gbps USB 3.0 port and two 480Mbps USB 2.0 ports.
- 4K HDMI Display: Enhance your visual experience with a hub capable of delivering 4K resolution at 30Hz in both mirror and extend modes. Please note that this hub is compatible with MacBook (macOS 12 and newer), Windows 10 and 11, ChromeOS, and laptops equipped with DP Alt Mode and Power Delivery. Note: This device is not compatible with Linux.
- What You Get: Anker USB-C Hub (5-in-1, 4K HDMI), welcome guide, 18-month warranty, and our friendly customer service.
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
