Tableau Charts for Analysts: Bars, Lines and Scatter Plots That Answer Questions
Choose Tableau charts that answer questions: bars for categories, lines for time and scatters for correlation and outliers.
Stakeholders do not ask for "a scatter plot" — they ask "which customers lose money?" The analyst translates questions into the smallest chart that answers it. This guide synthesises scripts 04 and 05 into a decision framework for bars, lines and scatters on Superstore, linking encoding to chart purpose.
Foundations in Tableau Data Types and Roles and Tableau Marks Card are prerequisites; build after connecting in Tableau Connecting Data Sources.
Which chart answers which question?
Question → Chart mapping Tableau Help: Build Charts:
- Compare categories → Bar: Profit by Segment or Region.
- Show trend over time → Line (continuous Date): Profit by Month/Time.
- Test relationship + outliers → Scatter: Profit vs Sales per Customer ID.
Show Me helps: select fields, open Show Me, and Tableau highlights viable charts Tableau Help: Scatter. Prefer simplicity — if a bar answers, avoid a scatter.
How do you build bars and lines?
Rows/Columns + Marks Card Tableau Help: Marks.
- Bar: Drag Segment (blue discrete) to Columns, SUM(Profit) to Rows. Drag SUM(Profit) to Color for gradient or Category (blue) to Color for distinct hues — as in Marks Card guide.
- Line: Drag Order Date continuous green to Columns, SUM(Profit) to Rows. Tableau draws one line. Use Color (discrete) to split lines per Region, Size to emphasise high profit, and Label > Min/Max only.
// Bar encoding
// Columns: [Segment] Rows: SUM([Profit]) Color: SUM([Profit])
// Line encoding
// Columns: [Order Date] (green continuous) Rows: SUM([Profit]) Color: [Region] (blue)If your line looks like separated bars, your Date is discrete blue — switch to continuous green.
How do you build a scatter for correlation?
Columns + Rows + Detail Tableau Help: Scatter from script 05:
- Sales to Columns, Profit to Rows.
- Customer ID to Detail — one point per customer.
- Optional: Quantity to Size, Country to Color/Shape, Marks to Filled Circles, Opacity 65% + Border.
This maps four dimensions without overloading perception. Test by removing Detail — scatter collapses to one point, proving entity granularity matters.
How do you keep charts analyst-grade?
Hygiene rules Tableau Help: Marks:
- One primary encoding: If Color already shows profit, do not also map Profit to Size and Label.
- Labels restricted: Lines get Min/Max only; scatters get none (use Tooltip hover for values).
- Colour ≤4 categories: More need a filter or grouping.
Gotcha: Detail Omission Flattens the Scatter
You build Sales vs Profit and get a single dot — you forgot Detail. Without Customer ID on Detail, Tableau aggregates to SUM, not per-entity. Always place the entity dimension on Detail for scatters; this is the number-one portfolio correction for ₹5–10 LPA candidates.
Quick reference
| Question | Chart | Key Pill Handling |
|---|---|---|
| Profit by Segment? | Bar | Segment blue discrete to Columns |
| Profit trend 2020-24? | Line | Order Date green continuous to Columns |
| Sales-Profit correlation? | Scatter | Sales/Cost to Columns/Rows + Customer ID to Detail |
| Noisy daily trend? | Line + Table Calc | Add Moving Average from table calcs |
Move from charts to composition in Tableau Dashboards and interactivity in Tableau Parameters. Practice all three on Superstore before building your portfolio story.
Show Your Chart Judgment
Build one bar, one line and one scatter that each answer a business question, then sequence them into a story on your Data Analyst track.
Explore the Data Analyst TrackFrequently Asked Questions
Which Tableau chart should analysts use first?
Start with Bar for categorical comparisons, Line for time series on a continuous date axis, and Scatter for correlation and outliers. Cover 80% of stakeholder questions with these three.
How do you choose between bar and line for time?
Use bars when dates are discrete (blue YEAR/QUARTER headers for YoY) and lines when dates are continuous (green axis for trends and moving averages).
How do you build a scatter for correlation in Tableau?
Drag Sales to Columns, Profit to Rows, Customer ID to Detail, then map Size and Color. Use filled circles and 60-70% opacity to handle overplotting.
What is Show Me in Tableau?
Show Me is the chart recommendation panel that highlights valid chart types based on fields you selected, reducing the guesswork in chart choice.
How do you avoid chartjunk in analyst charts?
Limit each chart to one primary encoding, restrict labels to Min/Max, use Tooltip for secondary metrics, and keep colour to ≤4 categories.
Written by
Founder at Topfolio with 6+ years in data & analytics across JPMC, Ultrahuman, and high-growth startups. Sat on hiring panels, reviewed 500+ resumes, and writes practical SQL & data guides.
Related Articles
Tableau Dashboard Layout Guide: Containers, Tiled & Design
Master Tableau dashboard layout: configure Horizontal & Vertical tiled containers, manage Item Hierarchy, set padding, and choose between Stories vs Dashboards.
Tableau Marks Card Guide: Color, Size, Label & Visual Sorts
Master the Tableau Marks Card: encode data with Color, Size, Label, and Tooltip. Learn how to sort marks, control gradients, and format clean visual charts.
Tableau Parameters: Dynamic Filters and Top-N Without Rewriting Formulas
Create Tableau Parameters for dynamic threshold and Top-N RANK filters without rewriting formulas. Slider and list controls.