AirSheet supports inserting Column charts to visually display data size comparisons and trend changes.

Feature Description

Feature Dimension Description
Membership Restriction No membership restriction
Version Restriction No version restriction

Operation Steps

Insert Bar Chart

Feature Entry
「Insert」 tab → 「Chart」 → 「Column Chart」

  1. Select the cell range containing data (ensure category headers and values are included)
  2. Click the 「Insert」 tab, select 「Column Chart」
  3. Then select a specific subtype (Clustered Column Chart, Stacked Column Chart, etc.)
  4. The bar chart will be automatically generated and can be dragged to adjust its position and size

image

FAQ

Q1: Column chart data points are misaligned and labels are disordered?

  • Solution: The data source contains empty rows/columns or merged cells causing interference. Delete empty rows/columns, unmerge header rows, and then reselect the range to insert the chart again.

Notes

  1. The data source should contain continuous header rows and values; avoid empty rows and columns
  2. Right-click the chart → 「Edit Chart」 to edit chart elements and chart data
  3. You can also quickly insert a Column chart by click「Chart」button from the「Home」tab