Home > CNFANS: Visualizing Your Spending and Freight Data

CNFANS: Visualizing Your Spending and Freight Data

2026-02-13

Transform your spreadsheet numbers into clear, actionable insights with powerful graphs.

Managing logistics and finances for cross-border purchases can be overwhelming. The CNFANS Spreadsheetsee

Step 1: Prepare Your Data in CNFANS

Before creating any visuals, ensure your data is clean and consistent.

  • Spending Data:Product Cost, Domestic Shipping, International Freight, Tariffs, Agent Fees).
  • Freight Data:Courier Name (e.g., UPS, DHL, EMS, SAL), Ship Date, and Delivery Date.
  • Use separate sheets or columns clearly labeled for each data type.

Step 2: Generating Spending Analysis Graphs

Your goal is to see which categories consume most of your budget.

Recommended Chart: Pie Chart or Bar Chart

A Pie ChartBar Chart

How to Create It:

  1. Select your list of categories and their corresponding total amounts.
  2. In your spreadsheet tool (like Excel, Google Sheets), go to Insert     Chart.
  3. Choose "Pie Chart" or "Column Chart" (Bar Chart).
  4. Format the chart: Add data labels showing percentages or values for clarity.

Insight Gained:

Step 3: Generating Courier Speed Analysis Graphs

Your goal is to compare the delivery performance of different shipping methods.

Recommended Chart: Bar Chart or Line Chart (for trends)

A Bar ChartLine Chart

How to Create It:

  1. Calculate the delivery duration for each parcel: Delivery Date - Ship Date.
  2. Create a summary table listing each CourierAverage Delivery Days.
  3. Select this summary data.
  4. Go to Insert     Chart
  5. Consider sorting the bars from shortest to longest average time for instant clarity.

Insight Gained:

Step 4: Advanced Visualization – Combined Dashboard

For advanced users, combine both charts into a single dashboard view.

  • Place the Spending Pie ChartCourier Speed Bar Chart
  • Add filters (if your spreadsheet software allows) to view data for a specific time period (e.g., last quarter).
  • This dashboard gives you a holistic, at-a-glance view of your logistics cost and performance efficiency.

Conclusion

By moving from raw data in your CNFANS spreadsheet to visual graphs, you empower yourself to make smarter, data-driven decisions. Visualizing spending datafreight speed