Online Excel Chart Maker
Create Professional Charts Online from Your Excel Data
Customize Style
ExcelToChart Key Features
Easy & Quick Charts
Create professional charts instantly by selecting an Excel file. No Excel expertise required - just adjust settings and generate.
Data Privacy First
Files processed locally in your browser. No data upload needed, ensuring complete privacy and security of your sensitive information.
Multiple Chart Types
Create various chart types including bar, line, pie, scatter and combo charts to best visualize your data.
Advanced Combo Charts
Create dynamic combination charts that blend bar and line elements with dual Y-axes, ideal for visualizing multi-scale data relationships.
Custom Styling
Customize every aspect of your charts with real-time preview - from color themes and margins to grid lines and legends.
Data Analysis Tools
Flexible dimension selection and data aggregation options. Support various Excel summarize values and show value functions.
Dynamic Data Filtering
Filter your data using flexible operators like greater than, less than, contains, or top N items—and build charts from the refined dataset.
Responsive Viewing
View charts on any device with full-screen support, zoom capabilities, and interactive data tooltips perfect for presentations.
FAQs
How do I customize the chart style?
Click the 'Customize Style' text button below the 'Create' button to open a dialog. The dialog contains three tabs with different style settings available for your selected chart type:
- Basic: Chart width, margin settings, bar orientation for bar charts, etc.
- Style: Background color, color schemes, line styles, etc.
- Axes & Legend: Axis labels, pie chart label settings, and legend configurations, etc.
Each tab provides specific customization options to help you achieve your desired chart appearance.
How do I adjust the spacing between the chart and legend?
If your legend overlaps with the chart or appears too close/far, you can adjust the spacing in these steps:
- Click 'Customize Style'
- Go to the 'Basic' tab
- Find 'Margin Settings'
- Adjust the margin values:
- For right-side legends: Adjust the 'Right' margin value
- For top legends: Adjust the 'Top' margin value
- For bottom legends: Adjust the 'Bottom' margin value
- For left-side legends: Adjust the 'Left' margin value
Each margin setting controls the spacing between the chart and its outer boundaries, allowing you to fine-tune the layout.
Does the chart use all data from my Excel file?
No. Data is first read from your selected sheet (default is the first sheet), which you can filter and summarize. By default, the chart will display up to 500 rows of data (adjustable in 'Data Display Limits' under 'Advanced Options').
Usually, 500 rows are sufficient for creating meaningful charts. If you want to better represent overall data characteristics, you can choose 'Sample N Rows Evenly' or 'Sample N Rows Randomly' in 'Overflow Handling' to sample up to 500 rows either evenly or randomly.
How do I create a chart with two Y-axes?
You can create a chart with two Y-axes using a Combo Chart, which allows you to display data with different units or scales using separate Y-axes:
- A primary axis (left side)
- A secondary axis (right side)
To create one:
- Select 'Combo Chart' in the Chart Type dropdown
- Configure both axes in 'Dual Y-Axis Settings':
- Choose chart types for each axis
- Select which columns to display on the primary axis (remaining columns will automatically use the secondary axis)
This is particularly useful when comparing data with different units or scales (e.g., quantity vs. price).
What is 'Show Values As' and when should I use it?
'Show Values As' determines how your calculated results are displayed in the chart. Common options include:
- No Calculation: Shows raw data (useful for duplicate dimension values)
- Row Total: Shows the sum of selected columns for each row
- Adjacent Column Difference: Shows the difference between each column and the previous one
Choose the option that best presents your data story.
What is 'Summarize Values By' and how does it work?
'Summarize Values By' determines how your raw data is calculated. It allows you to:
- Sum up values
- Count occurrences
- Calculate averages
This feature automatically processes your raw data when creating charts, eliminating the need for pre-processing in Excel. The final display depends on your 'Show Values As' selection.
How are duplicate values in the Label/X-Axis Column handled?
By default, only the first row with a duplicate label/x-axis value is used. To summarize these data:
- Enable 'Data Summary' in 'Configure Chart'
- Choose a 'Summarize Values By' option (Sum, Average, etc.)
- Set 'Show Values As' to 'No Calculation'
What happens if Data Columns contain non-numeric values?
Any non-numeric values in Data Columns (excluding the Label/X-Axis Column) will automatically be converted to 0 during chart creation.