Excel: Connecting the dots between inconsistent data
October 15, 2006 10:16 AM Subscribe
Excel: I am trying to create a line graph of last year's workload versus this year's workload. Problem is, I don't have consistent data and my graphs have numerous gaps between data points. How can I best fill these gaps?
posted by Ziggy Zaga to Computers & Internet (6 answers total)
When making the graph, I can't figure out how to get Excel to just ignore missing data and connect the dots between the data I do have. This would be an adequate solution for me because I'm just looking at trends; not quantitative specifics.
I have tried using the "fill series" function to fill in the missing numbers but the numbers it provides are wildly inaccurate.
If anybody can tell me how to get Excel to connect the dots, or if a better solution is in order, I would appreciate it.