Create Google Sheets Charts with AI Add-ons

## 1) Recommended Chart
**Combo Chart (Column + Line)** — columns show monthly revenue with top-3 highlighted; line overlays the revenue trend.

## 2) Data Setup (A1:E13)
Headers in row 1: `Month | Revenue | Units | Top3 Revenue | Other Revenue`

Helper formulas (fill D2:E13):
- **D2:** `=IF(RANK(B2,$B$2:$B$13)<=3, B2, 0)`
- **E2:** `=IF(RANK(B2,$B$2:$B$13)<=3, 0, B2)`

This splits revenue into two series so top-3 months render in a highlight color.

## 3) Build the Chart
1. Select **A1:E13** → **Insert > Chart**.
2. **Setup tab:**
   - Chart type: **Combo chart**
   - X-axis: **Month**
   - Series: remove Units; keep **Top3 Revenue**, **Other Revenue**, **Revenue**
   - Set **Revenue** series to **Line**; Top3/Other as **Columns**
   - Check **Stack > Standard** (so columns align per month)
3. **Customize tab:**
   - **Series → Top3 Revenue:** color **#E8710A** (orange), data labels **On**
   - **Series → Other Revenue:** color **#B7B7B7** (gray)
   - **Series → Revenue (line):** color **#1A73E8**, thickness 3
   - **Chart & axis titles:** "2024 Monthly Revenue — Top 3 Highlighted"
   - **Vertical axis:** format as Currency

## 4) AI Add-on: GPT for Sheets and Docs
Install from Workspace Marketplace. In cell **G2**, write:
`=GPT("Summarize 2024 revenue trend, name top 3 months, and flag anomalies:", A1:C13)`
Set **Extensions > GPT for Sheets > Settings > Auto-refresh: Monthly** so insights update as you add rows.

## 5) Optional Enhancement
Add a **Trendline** on the Revenue line: Customize > Series > Revenue > **Trendline: Linear**, Label: **Equation**, Opacity 0.4 — reveals the growth slope at a glance.

# Revenue Trends Visualization & AI Insights

## 1. Recommended Chart
**Combo Chart (Line + Column)** – Line shows revenue trend clarity; columns highlight monthly volume for comparison.

## 2. Data Setup

**Primary data:** A1:C13 (Month, Revenue, Units Sold)

**Helper column (D) – Top 3 Flag:**
- D1: `Top 3 Month`
- D2: `=IF(COUNTIFS($B$2:$B$13,">="&B2,$B$2:$B$13,">"&B2)<3,"Yes","No")`
- Copy D2 down to D13

## 3. Build Steps in Google Sheets

1. Select A1:B13 (Month + Revenue)
2. **Insert > Chart**
3. **Chart type:** Combo chart
4. **Series tab:**
   - Series 1 (Revenue): Column chart
   - Add Series 2 (Units Sold): Line chart
5. **Customize tab:**
   - Title: "2024 Monthly Revenue & Units Sold"
   - X-axis: Month
   - Enable data labels on Revenue columns
   - Color Revenue bars by Top 3 (use conditional formatting rule: If D="Yes", highlight gold)

## 4. AI Add-On: **GPT for Sheets**
- Install from Add-ons > Get add-ons
- Column E formula: `=GPT("Analyze this month's revenue: "&B2&" units. Trend vs previous month?")`
- Refresh monthly to auto-populate insights tied to new data

## 5. Optional Enhancement
**Dynamic Range:** Replace A1:B13 with `A1:B&COUNTA(A:A)` to auto-expand when new months are added.

## 1) Best Chart
**Combo chart (line + highlight points)** — best for showing **Revenue over time** while clearly marking the **top 3 months**.

## 2) Data Setup
Assume headers in **A1:C1** and data in **A2:C13**.

1. In **D1**, enter: `Top 3 Revenue`
2. In **D2**, paste and fill down to **D13**:  
   `=IF(RANK(B2,$B$2:$B$13,0)<=3,B2,NA())`

This creates a helper series that only shows the top 3 revenue months.

## 3) Build the Chart
1. Select **A1:D13**
2. Click **Insert > Chart**

### Setup tab
3. **Chart type:** `Combo chart`
4. **Data range:** `A1:D13`
5. **X-axis:** `A2:A13`
6. **Series:**  
   - `Revenue` = `B2:B13`  
   - `Top 3 Revenue` = `D2:D13`
7. Make sure **Use row 1 as headers** and **Use column A as labels** are ON.
8. In Series settings:
   - **Revenue:** Type = `Line`
   - **Top 3 Revenue:** Type = `Scatter`

### Customize tab
9. **Chart & axis titles**
   - Chart title: `2024 Monthly Revenue Trend`
   - Horizontal axis: `Month`
   - Vertical axis: `Revenue`
10. **Series > Revenue**
   - Line color: blue
   - Point size: 4
11. **Series > Top 3 Revenue**
   - Color: red
   - Point size: 8
   - Data labels: ON

## 4) AI Add-on
**GPT for Sheets and Docs**

1. Install from **Extensions > Add-ons > Get add-ons**
2. Use a prompt in a cell like:  
   `=GPT("Summarize sales trends and explain why these top 3 revenue months stand out based on Month, Revenue, and Units Sold.")`
3. Refresh monthly by extending data and re-running the formula.

## 5) Optional Enhancement
**Trendline:** In **Customize > Series > Revenue > Trendline = Linear** to show overall sales direction.

### 1. Recommended Chart

A **Combo Chart** is best. It allows you to display the overall monthly revenue as columns while using a second, overlapping series to highlight the top-performing months in a different color.

### 2. Data Setup

1.  Your data should be in `A1:B13` (headers in row 1).
2.  In cell `D1`, enter the header `Top 3 Revenue`.
3.  In cell `D2`, enter this formula to identify the top 3 values:
    `=IF(B2>=LARGE($B$2:$B$13,3), B2, NA())`
4.  Drag this formula down from `D2` to `D13`. This helper column will only show values for the top 3 months.

### 3. Chart Building Steps

1.  Select both ranges `A1:B13` and `D1:D13` by holding Ctrl (or Cmd on Mac).
2.  Go to **Insert > Chart**.
3.  In the **Chart editor > Setup** tab:
    *   **Chart type**: Combo chart
    *   **X-axis**: `A1:A13`
    *   **Series**: Ensure `Revenue` and `Top 3 Revenue` are added as column series.
4.  Switch to the **Customize** tab:
    *   Go to **Series**. Select the "Top 3 Revenue" series and change its color to a bright, contrasting color (e.g., gold or green).

### 4. AI Add-on Recommendation

Use the **Coefficient** add-on. After installing it, you can auto-generate insights. In a cell, use the formula `=COEFFICIENT("Summarize the sales trends and top months from this data: "&ARRAYTOTEXT(A1:B13))`. Schedule this formula to auto-refresh monthly from the add-on's sidebar.

### 5. Optional Enhancement

Add a **Trendline** to show the overall sales direction. In the **Chart editor > Customize > Series** tab, select the "Revenue" series, scroll down, and check the "Trendline" box.

### Recommended Chart
Combo (line + columns): Line shows revenue trend over time; columns highlight top 3 months.

### Data Setup
1. D1: `Top 3 Revenue`
2. D2: `=IF(RANK(B2,$B$2:$B$13,0)<=3,B2,NA())` → drag to D13.

### Build Instructions
1. Select A1:D13 → Insert > Chart.
2. **Setup tab**: Chart type: Combo chart; X-axis: A1:A13 (Months); Series: Add B1:B13 (Line, left axis), D1:D13 (Columns, right axis); Aggregation: None.
3. **Customize tab**: Chart style: Maximize; Series B: Line color blue, smooth line; Series D: Column color red, bold; Horizontal axis: Title "Month"; Vertical axis (left): Title "Revenue".

### AI Add-on
GPT for Sheets: Install from Google Workspace Marketplace. In F1: `=GPT("Monthly revenue insights from A:C; highlight trends & top months")` → auto-refreshes on edit/open.

### Optional Enhancement
Add trendline: Customize > Series > B1:B13 > Trendline > Linear. 

(148 words)