Bar Graph Maker
Grouped, stacked, horizontal and diverging bar charts from your numbers.
First column: labels. Other columns: numbers, one column per series. Or one “label: value” per line.
Chart
Arrow keys move from value to value; up and down switch series; Escape hides the tooltip.
Chart data as a table
About the Bar Graph Maker
Paste a table from Excel or Google Sheets, open a CSV or Excel file, or just type one label: value per line, and get a clean bar graph in seconds. Pick grouped bars to compare series side by side, stacked bars to show how parts add up, 100% stacked bars to compare shares, or diverging bars for a population pyramid or a Likert-scale survey.
Bars can run up (columns) or across (horizontal bars, best for long labels). Sort them, add value labels and totals, draw an average or target line, and format numbers as ₹, lakh/crore, K/M or percentages. Download a PNG at up to 4× resolution or an SVG that stays sharp at any size. Everything happens in your browser.
How to use it
- Paste your data into Your data (the first row can hold the column names), or choose Open file for a CSV or Excel sheet. A single list such as
Rent: 18000on each line works too. - Under Bar chart, choose the column with the labels and tick the columns of numbers to show.
- Pick a layout — grouped, stacked, 100% stacked or diverging — and whether the bars stand up (columns) or lie across (bars).
- Optionally sort the bars, turn on value labels, and add an average or a target line.
- Type a title and axis titles, and set the number format (₹, lakh/crore, %) and colours under Colours, text & numbers.
- Choose Download PNG or SVG, copy the image, or copy a share link.
Examples
Rent: 18000 Groceries: 9500 Transport: 4200
Three columns labelled Rent, Groceries and Transport
Each line is a label and a number; = or a space works instead of the colon.
Region 2025 2026 North 42.5 48.1 South 38.2 44.7
Two columns per region, one for each year, with a legend
Years as column names are recognised as names, not numbers.
Question, Disagree, Neutral, Agree Price, 40, 25, 35
One bar per question: disagree to the left of the centre line, neutral straddling it, agree to the right — as % of answers
With three or more answer columns the first half goes left, a middle column becomes neutral, and each row is shown as 100%.
Common uses
- Comparing sales, marks or survey results across categories.
- Showing a budget or expenses broken down by category and month (stacked).
- Population pyramids by age group and sex for geography or social-science work.
- Customer or employee survey results on an agree–disagree scale.
- Profit and loss by month, with negative bars below zero.
Which layout to choose
- Grouped — compare the same categories across a few series (2025 vs 2026).
- Stacked — show totals and what they are made of; only the bottom segment shares a baseline, so the other segments are harder to compare.
- 100% stacked — compare shares (mix) when totals differ; each bar is scaled to 100%.
- Diverging — two directions from a centre line: male/female in a population pyramid, or disagree/agree answers.
- Horizontal bars — best when labels are long or there are many categories.
Honest bar charts
A bar’s length stands for its value, so the value axis always starts at zero here: cutting the axis would make a 5% difference look like a 50% one. If you set the axis start above zero yourself, the tool warns you. Negative values hang below (or left of) the zero line. Missing cells leave a gap instead of a zero bar.
Diverging bars: pyramids and Likert scales
For a population pyramid, put age groups in the first column (oldest first, so it ends up at the top) and one column each for male and female; choose Diverging and Horizontal. The first series goes left; the axis shows sizes without minus signs.
For a Likert scale, put one row per question and one column per answer, from the most negative to the most positive. Negative answers stack to the left of the centre, positive ones to the right, and an odd middle answer (Neutral) straddles the centre. Rows are shown as a share of all answers so questions with different numbers of answers compare fairly. The red–blue and orange–purple colour scales are ColorBrewer schemes rated colour-blind safe.
Number formats
Automatic uses what your data shows: ₹ amounts become rupees (and lakh/crore once they reach a lakh), % stays %. You can also pick Indian grouping (12,34,567) or international (1,234,567), short forms such as 1.2K, 3.4M or ₹12.35L and ₹1.2Cr (the Unicode CLDR en-IN abbreviations), a fixed number of decimals, and your own text before or after each number.
Limitations
- Up to 300 categories and 60 columns; summarise larger tables first (for example with a pivot table).
- Cells that are not numbers (such as “lots” or “TBD”) are left out and listed under the data; “n/a”, “-” and empty cells are treated as missing.
- Bars cannot use a log scale (a bar needs a zero baseline); use the Line Graph Maker for that.
- The PNG uses your device’s system font; the SVG names common system fonts, so it can look slightly different on another computer.
Privacy
Everything happens in your browser. What you enter or open here is not uploaded or stored by MySmartCoPilot.
Frequently asked questions
How do I make a bar graph from Excel or Google Sheets?
Select the cells (with the header row), copy them, and paste into Your data. Spreadsheets copy cells as tab-separated text, which is read as a table. You can also save the sheet as .xlsx or .csv and use Open file.
How do I make a double (grouped) bar graph?
Give each series its own column of numbers — for example 2025 and 2026 next to each region — and keep the layout on Grouped. Each category then gets one bar per column, with a legend.
What is the difference between a bar chart and a column chart?
Only the direction: columns stand up from the x axis, bars lie across from the y axis. Horizontal bars are easier to read when labels are long. Switch with Columns / Bars.
Can I show negative numbers?
Yes. Negative values hang below the zero line (or to its left on horizontal bars). In stacked bars, positive parts stack up and negative parts stack down from zero.
How do I add a target or average line?
Tick Average line for the mean of the first series (or of the totals for stacked bars), or type a number under Target line — ₹ and lakh/crore are understood, so ₹2.5 lakh works.
Is my data uploaded anywhere?
No. The data, the chart and the files you download are made in your browser. A share link carries the data inside the link itself, after the “#”, which browsers never send to a server.