Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: How to synch up series with missing data?

27 Sep 2010   #1

Win 7 Pro 64-bit
How to synch up series with missing data?

The OLD EXCEL WAS INTUITIVE to use. OK, the new one may be easy, if not intuitive, but I cannot find the features I am looking for.

I have an existing chart already, I added additional series to it.

When the series contains all the data, of course, that's trivial and it plots correctly.

When the series contains missing data, the series plots in the wrong location!
It SHOULD appear shifted to the right, synchronizing on the common values of the X axis. Instead, it plotting data points on a first come first served basis.

See attached. I sketched in where the data SHOULD be plotting.

I have hand typed these values, so I don't expect any "data type" or "data format" issues, which I already know can cause bogus results. I cannot see the problem though.

Attached Images
My System SpecsSystem Spec

27 Sep 2010   #2

Win 7 Pro 64-bit

RESOLVED - there is an option to show ZERO values or show GAPS. That plots the data correctly. Thanks.
My System SpecsSystem Spec

 How to synch up series with missing data?

Thread Tools

Similar help and support threads for2: How to synch up series with missing data?
Thread Forum
Missing data after full install from XP General Discussion
Bookmark backup/Synch for IE Browsers & Mail
Win7 FTP get command - missing data? Network & Sharing
FO3 Missing Data Folder Gaming
Missing boot menu and missing data partition Installation & Setup
about 10GB missing data General Discussion
Activ synch problems Hardware & Devices

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 08:37 PM.
Twitter Facebook Google+

Windows 7 Forums

Seven Forums Android App Seven Forums IOS App

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33