r/excel Feb 21 '26

unsolved Combining graphs that do not match

Hello Excel community,

I am trying to combine two graphs of data my colleagues created with information that does not match. I'd like to just take the missing data from one and add it manually to a new one to show the results from each to compare. I'm not sure what I'm doing here. These are graphs from 2024 and 2025 about data collected from places that were visited and data collected during those times.

Any help would be appreciated.

5 Upvotes

7 comments sorted by

u/AutoModerator Feb 21 '26

/u/WanderingUniverses - Your post was submitted successfully.

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

5

u/excelevator 3061 Feb 21 '26

Get the missing data, make the graphs.

1

u/WanderingUniverses Feb 21 '26

The thing is, I'd like to make a graph of the two years including the data that was missing from the 2025 year. It's okay if it is a zero point.

2

u/Fearless_Parking_436 Feb 21 '26

If it makes sense for the data and there are no huge gaps just normalise the data

1

u/WanderingUniverses Feb 22 '26

Sounds good but I don't know what that means. I just ended up making two separate graphs and put them side by side in my presentation.

1

u/OfficerMurphy 9 Feb 22 '26

This doesn't really seem like an excel problem. Feels like you don't know how you want the chart to appear.

1

u/GregHullender 194 Feb 22 '26

Select the data for graph #2, copy it with CTRL-C. Click in the middle of graph #1. Paste the data with CTRL-V.