Calculator Bar

Bar Graph Maker

Bar Graph Maker

Your data

| | | |

Type in the table: Tab moves across, Enter moves down and adds a row at the bottom. You can paste a block of cells from Excel or Google Sheets into any cell, or drop a CSV file here.

Bar graph—

    How to use the bar graph maker

    1. Enter your data in the table. Put the categories (months, fruits, subjects) down the first column and the numbers beside them. Name each column of numbers in the top row; with two columns you get a double bar graph.
    2. Move quickly: Tab goes to the next cell, Enter goes down a row, and pressing Enter on the last row adds another. Use Add a row and Add a column for more.
    3. Already have the data somewhere? Copy a block of cells from Excel or Google Sheets and paste it into any cell: it fills the table from there. A CSV file can be opened with Open a CSV file or dropped onto the table.
    4. Copied from a PDF or a web page? Open Paste data instead, paste it there and press Make graph.
    5. Download the PNG to put in a document or slide, or copy the table into Word, Google Docs or a spreadsheet.

    The graph redraws as you type. Rows you leave empty are ignored, and a missing number in a row you've started gets a red dashed outline. If your rows and columns come out the wrong way round, use Swap rows and columns. With two or more series you can show the bars side by side, stack them, or give each series its own graph, which is best when the series are measured in different units.

    Pasting from a PDF or worksheet

    A table copied out of a PDF usually arrives as one long line, with the labels and numbers mixed up. For example:

    2019 month jan feb mar … carbon monoxide (ppb) ozone (ppb) … 15 15 10 12 …

    The maker sorts each word into a bucket: month names become the categories, words such as carbon monoxide (ppb) become series names, a year at the start becomes part of the title, and everything else that looks like a number is a value. If 48 numbers turn up with 12 months and 4 labels, it fills a table of 4 series × 12 months in the order the numbers appear.

    It can't know for sure that this is the order your worksheet used, because the PDF copy threw that information away. So the answer says the order was guessed. Put the worksheet next to the table and check every value before you hand anything in.

    How to draw a bar graph by hand

    1. Draw the two axes: categories along the bottom (or the side, for horizontal bars) and values up the side.
    2. Choose a scale. Start at 0, go a little past your biggest value, and use equal steps such as 0, 5, 10, 15 or 0, 20, 40, 60.
    3. Draw one bar per category, all the same width, with equal gaps between them. Each bar goes up to its value on the scale.
    4. For a double bar graph, draw the two bars for each category side by side in two colors, and add a key that says which color is which.
    5. Label both axes, including units such as ppb or number of students, and give the graph a title.

    Choosing a scale

    Divide your biggest value by about 5 and round up to a friendly step: 1, 2 or 5 times a power of 10 (so 1, 2, 5, 10, 20, 50 and so on). For a biggest value of 73, 73 ÷ 5 = 14.6, which rounds up to a step of 20, so the scale runs 0, 20, 40, 60, 80. This is the rule the maker uses for its gridlines.

    Biggest valueStepScale
    1250, 5, 10, 15
    1850, 5, 10, 15, 20
    73200, 20, 40, 60, 80
    3401000, 100, 200, 300, 400
    8,6002,0000, 2,000 … 10,000

    Need the average of each series too? Paste the numbers into the average calculator. To graph an equation such as y = 2x + 3 instead of data, use the graphing calculator.

    Frequently asked questions

    How do I make a bar graph from a table of data?

    Put the categories (months, subjects, names) along one axis and the numbers along the other. Pick a scale that starts at 0 and goes a little past your biggest value, draw one bar per category to its value, then label both axes and give the graph a title. This bar graph maker does all of that for you from a pasted table.

    What is a double bar graph?

    A bar graph with two bars for each category, one per data set, side by side in two colors with a key. It compares two groups across the same categories, such as boys and girls by favorite subject, or this year and last year by month. Paste a table with two columns of numbers to make one.

    My pasted data came out in the wrong order. What happened?

    Copying a table out of a PDF often loses the rows and columns, so the numbers arrive in one long line. The maker then fills the table in the order the numbers appear and tells you it had to guess. Check each value in the table against your worksheet and type over any that are wrong; the graph redraws as you type.

    Should a bar graph start at zero?

    Yes. The length of each bar is what readers compare, so the value axis should start at 0. A scale that starts at 50 makes a bar of 60 look several times bigger than a bar of 55. Line graphs can start elsewhere; bar graphs shouldn't.

    What's the difference between a bar graph and a histogram?

    A bar graph compares separate categories, such as fruits or months, and its bars have gaps between them. A histogram shows how a set of measurements is spread over number ranges, such as heights from 150 to 160 cm, and its bars touch because the ranges join up.

    See also

    Last updated: November 16, 2026