“Combining two charts” in Excel can mean placing two data series into one chart, creating a combo chart with different chart types, or simply aligning two separate chart objects. If the data should be compared in a single visual, add both series to one chart rather than trying to merge two finished chart images.
Add another series to an existing chart
- Arrange both data series with clear labels and compatible category values.
- Select the existing chart.
- Use Select Data to add the second series and specify its values and name.
- Verify that the horizontal-axis categories align correctly.
Use a combo chart when the series need different visual forms
You can display one series as columns and another as a line through Excel’s Change Chart Type/Combo controls. This is useful when the chart types communicate different aspects of related data.
Use a secondary axis cautiously
If the two series have genuinely different units or scales, a secondary axis can make both visible. Label each axis clearly. Dual axes can exaggerate apparent relationships when their scales are chosen poorly.
A single chart works best when the series share meaningful categories or a common x-axis. If one chart shows months and another shows unrelated product categories, combining them can make the result harder to understand.
If you only need two charts side by side
Keep them as separate chart objects and use Excel’s alignment and sizing tools. That preserves independent axes and can be clearer than forcing dissimilar information into one plot.
Check the result, not just the formatting
Make sure legends, units, labels, category order, and axis scales still communicate the data accurately after the series are combined.
Matt Jacobs has been working as an IT consultant for small businesses since receiving his Master’s degree in 2003. While he still does some consulting work, his primary focus now is on creating technology support content for SupportYourTech.com.
His work can be found on many websites and focuses on topics such as Microsoft Office, Apple devices, Android devices, Photoshop, and more.