Bar Chart Generator

Create bar charts and column charts online, with support for data import, custom styles, real-time preview, and export to PNG, JPG, and SVG formats.

Bug report

Browser execution mode: Your data is processed in your browser and is not uploaded to the server.

Speed and Stability: Processing speed depends on your device and browser. For large batch work, the desktop version may be more stable.

Loading tool, please wait...

If the online tool fails to load or run, try the desktop tool.https://tools.yikeaigc.com/

Tool Usage

Return to old version

Set data and chart options first, then generate the bar chart. File imports are parsed on this page. For batch processing, only the first 20 files are shown, but all files are processed when generating.

1Choose data source

2Chart text

Chart title

Subtitle

Category axis title

Value axis title

3Edit data table

Supports single series, multiple series, grouped, and stacked

3Paste table data

Supports comma, Tab, and semicolon delimiters

Data content

For a single series, use “Category,Value,Color”; for multiple series, use “Category,Series 1,Series 2”. The first row can be a header.

3Import data file

All files will be processed in batch generation

Click to choose files, or drag files here Supports .csv, .txt, .xlsx, .xls; first column is categories, later columns are values

After the data is ready, continue to set the bar chart style.

1Chart Structure

Chart Direction

Series Mode

Sort By

Items to Show

2Size & Text

Chart Width (px)

Chart Height (px)

Label Font Size (px)

Title Font Size (px)

Category Label Angle

Bar Corner Radius (px)

Bar Width

Number Format

Show title Show legend Show gridlines Show value labels Show axis titles Value axis includes 0

3Colors & background

Background color

Text color

Axis color

Grid color

Transparent background

1Generate & download

Export filename

Image resolution

JPG quality

Batch formats

Generate a preview before downloading the chart.

2Data overview

Categories-

Series-

Total value-

Larger value-

Smaller value-

3Batch files

After selecting multiple data files, use “Batch ZIP” to generate at once. The first 20 files are shown; the ZIP includes all results.

Chart preview

Bar chart preview will appear here after generation

Instructions

Software Usage Instructions

Select a data source: You can use table input, paste data, or import a file. Table input is suitable for small amounts of data, pasted data is suitable for copying content from Excel or CSV, and file import supports CSV, TXT, XLSX, and XLS formats.
Organize the data table:
- Category name: Enter the category name corresponding to each column or bar, such as month, product, or region.
- Data series: Multiple series can be added to create multi-group comparison charts.
- Color settings: For a single series, you can set a color for each category; for multiple series, you can set a color for each series.
Set the chart structure:
- Chart orientation: Choose a vertical column chart or a horizontal bar chart.
- Series mode: Choose grouped display, stacked display, or percentage stacking.
- Sorting method: Keep the original order, or sort by total value in ascending or descending order.
- Display quantity: Show only the top 5, top 10, top 20, or top 30 items.
Adjust style parameters:
- Chart size: Set the width and height to fit reports, PPT presentations, or web display.
- Text style: Set the title font size, label font size, category label angle, and number format.
- Display options: Control the title, legend, gridlines, value labels, and axis titles.
- Color and background: Choose a color scheme, or separately set the background, text, axis, and grid colors.
Generate preview: Go to the “Generate & Export” step and click “Generate Preview” to view the chart. If changes are needed, return to the data or style step to continue adjusting.
Export files: You can export PNG, JPG, SVG, and CSV. When multiple data files are selected, you can use “Batch ZIP” to generate a compressed package. The result file names will retain the original file names as much as possible, and numbers will be automatically added to distinguish duplicates.
Save settings: Click “Save Settings” to save the current chart style and export parameters, making it easy to reuse the same configuration later.

FAQ

A: CSV, TXT, XLSX, and XLS files are supported. It is recommended to enter category names in the first column and values in the following columns. For single-series data, you can also use the three-column format “category, value, color”.

A: Grouped column charts are suitable for comparing multiple series side by side; stacked column charts are suitable for showing totals and the composition of each part; percentage stacking is suitable for comparing the proportional structure of different categories.

A: Choose a vertical column chart when category names are short and there are fewer categories; when category names are longer or there are many categories, a horizontal bar chart is usually easier to read.

A: PNG, JPG, SVG, and CSV export are supported. PNG is suitable for documents and presentations, JPG is suitable for general image use, SVG is suitable for scenarios that require scaling or post-editing, and CSV is used to save the current chart data.

A: During batch generation, the original data file name will be used as the result file name whenever possible. If files with the same name are encountered, numbers will be added to the file names to distinguish them, and they will be packaged into a ZIP file for download.

A: You can switch to a horizontal bar chart, increase the chart height appropriately, or use “Display Count” to show only key data such as the top 5, top 10, or top 20. You can also adjust the label angle and font size to improve readability.

A: You can increase the chart size, reduce the number of displayed categories, decrease the label font size, or turn off “Show Value Labels.” In stacked charts, when the value differences are small, turning off labels makes the chart cleaner.