Home > CNFANS: Visualize Your Spending & Freight Data

CNFANS: Visualize Your Spending & Freight Data

2026-02-04

Transform your spreadsheet numbers into actionable insights. Discover cost drivers and optimize shipping.

Why Visualize Your CNFANS Data?

Raw data in your CNFANS spreadsheet

  • Identify Major Cost Centers:
  • Compare Courier Performance:
  • Track Trends Over Time:
  • Make Data-Driven Decisions:

Step-by-Step: Generating Insightful Graphs

Step 1: Prepare Your Data

Ensure your CNFANS spreadsheet has clean, consistent columns. Essential data includes:

Column Needed Example Data Purpose
Category / Supplier "Electronics", "Home Decor", "Supplier A" For grouping costs
Item Cost / Total Spend $45.50, $120.00 The primary value to analyze
Courier Name "Courier X", "Courier Y" To compare delivery performance
Shipping Days / Date Range 5 days, "Order Date" & "Delivery Date" To calculate and visualize speed

Step 2: Create a "Spending by Category" Chart

To see which categories cost the most, generate a Pie Chart or Bar Graph.

  1. Highlight the columns containing your CategoriesTotal Spend
  2. Insert a Pie ChartColumn Chart
  3. Format the chart: Add data labels (values or percentages) and a clear title like "Total Spending by Product Category".

Example Bar Chart Output:

Total Spending by Category (Last Quarter)

Electronics

Apparel

Home Decor

Accessories

Insight:

Step 3: Create a "Courier Speed Comparison" Chart

To see which couriers deliver fastest, generate a Bar Chart or Line Graph.

  1. Calculate the Average Delivery Days
  2. Highlight the courier names and their corresponding average delivery times.
  3. Insert a Bar Chart
  4. Format the chart: Add a title like "Average Delivery Time by Courier" and label the axis clearly.

Example Horizontal Bar Chart Output:

Average Delivery Time by Courier (in Days)

Courier Express

Global Logistics

Standard Shipping Co.

Budget Freight

Insight:

Pro Tips for Deeper Analysis

Combine Cost & Speed

Create a scatter plot

Use PivotCharts

In Excel or Google Sheets, build a PivotTablePivotChart

Automate with Conditional Formatting

Use color scales

Conclusion: