Table of Contents
How to Make a Bar Chart in Excel
Create effective bar charts to compare and analyze data trends
Excel bar charts are essential tools for comparing data across different categories or over time. Whether you're tracking sales performance, analyzing survey responses, or presenting budget comparisons, bar charts provide a clear and effective way to visualize and communicate your data.
Try Online
Create bar charts instantly in your browser - faster and easier than Excel
Pro Mode
Try this
Drop Excel or CSV files here
Upload up to 2 files (10MB total)โข
Free Plan
Step-by-Step Guide
Learn how to create and customize bar charts in Excel
Basic Requirements
To create a bar chart, your data should: - Be organized in columns or rows - Include categories and their corresponding values - Have clear labels for each category - Contain numerical data for comparison
Creating a Bar Chart
1
Select your data range including headers
2
Click on the 'Insert' tab in Excel's top menu
3
In the 'Charts' group, click on the 'Insert Column or Bar Chart' button
4
Select the appropriate chart type: vertical columns (categories at bottom) or horizontal bars (categories on left)
5
Once inserted, right-click on chart elements to customize (e.g., add data labels, change colors)
6
Use the 'Chart Design' and 'Format' tabs for further customization
7
Double-click any chart element (like axes or titles) to adjust specific settings
8
When finished, you can move the chart to your desired location or resize it
Common Use Cases
Sales Comparison
Compare sales figures across different periods or regions
Performance Analysis
Track and compare KPIs or metrics over time
Survey Analysis
Visualize response distributions for different questions
Budget vs Actual
Compare planned versus actual spending across categories
Tips & Best Practices
- 1Use horizontal bars when category labels are long for better readability
- 2Start the value axis at zero to avoid visually misleading data comparisons
- 3Limit the number of data series per chart (typically 5-7) to keep it clean and readable
- 4Use meaningful titles and axis labels to ensure the chart can stand alone
- 5Consider your audience when choosing complexity and color schemes
- 6Use consistent colors for related data series to improve coherence
- 7For time series data, column charts (vertical) are typically better for showing trends
- 8Use stacked columns or bars to show both totals and component parts simultaneously
- 9When adding data labels, ensure they don't become overcrowded or overlap
Frequently Asked Questions about Bar Charts
Common questions and solutions for Excel Bar Charts
The primary difference is orientation: bar charts display data horizontally (categories on y-axis), while column charts display data vertically (categories on x-axis). Bar charts are better for: 1) Category names that are long (more readable horizontally), 2) Comparing many categories (horizontal space is often less limited), 3) Showing data over time when the time period isn't the main focus. Column charts are typically better for showing time series data and comparing fewer categories.
To sort a bar chart by values: 1) Select the chart, 2) Right-click on a bar and select 'Sort', 3) Choose 'Largest to Smallest' or 'Smallest to Largest'. Alternatively, sort your source data before creating the chart: select your data range, go to Data tab > Sort, and choose to sort by your value column. Sorting by value makes it easier to identify top performers, trends, and outliers at a glance.
To add data labels: 1) Select your bar chart, 2) Click the '+' button (Chart Elements) that appears, 3) Check 'Data Labels', 4) To customize, right-click on any label and select 'Format Data Labels', 5) Choose label position (end, inside, or outside end) and content (value, percentage, category name). Data labels help viewers see exact values without needing to reference the axis.
For proper date handling: 1) Ensure your date column is formatted as dates in Excel, 2) Select the chart, 3) Right-click on the category axis and select 'Format Axis', 4) Under Axis Options, set 'Axis Type' to 'Date axis' instead of 'Text axis', 5) Adjust the 'Base unit' to appropriate time units (days, months, years). This ensures dates are displayed at proper intervals and in chronological order.
To create a stacked bar chart: 1) Select your data (must have multiple data series), 2) Go to Insert > Charts > Insert Bar or Column Chart, 3) Select 'Stacked Bar'. For percentage view (each bar totals 100%): select '100% Stacked Bar'. Stacked bars work best when: 1) You're comparing parts-to-whole across categories, 2) You have 2-7 data series (too many makes it hard to read), 3) Your data tells a clear story about composition changes.
To add a secondary axis: 1) Select your chart, 2) Click on the data series that needs a different scale, 3) Right-click and select 'Format Data Series', 4) Under 'Series Options', check 'Plot Series On' and select 'Secondary Axis'. This is useful when comparing data with different magnitudes (e.g., quantity vs. price) or different units of measurement, making both trends visible on the same chart without smaller values being overwhelmed.
Excel automatically groups data when: 1) You have too many data points, 2) You're using dates or numbers as categories. To control grouping: 1) Right-click on the category axis, 2) Select 'Format Axis', 3) Under 'Axis Options', find and adjust 'Grouping' settings, 4) For dates, adjust binning options like 'By Month' or 'By Year'. To prevent automatic grouping, convert your category data to text format before creating the chart.
Add a benchmark line by: 1) Adding your target value as a separate data series with identical values for each category, 2) Select this series in the chart, 3) Right-click and select 'Change Series Chart Type', 4) Select 'Line' for this series only, 5) Format the line to stand out (red color, dashed style). Alternative method: use error bars set to a constant value, or add a vertical line using Shapes in charts where categories are on the y-axis.