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

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
How to synch up series with missing data?-wrong-plot.png How to synch up series with missing data?-missingdata.png 
My System SpecsSystem Spec
27 Sep 2010   #2


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
Thread Forum
Garage Series: Bringing Data Loss Prevention to SharePoint
Bookmark backup/Synch for IE
Is there such a thing? Chrome and FF import of bookmarks and backup is seamless. It took me half an hour to update IE bookmarks. And sorting them A-Z. is there an easier way? I'd like to start using IE some again--but this is WAY too labor intensive.
Browsers & Mail
MS Outlook / Blackberry 9700 Synch Problem
I was running MS Office Professional 2003 Upgrade and constantly used MS Outlook for ALL my contacts and e-mail. I bought a Blackberry 9700, had all my contact information copied from the older phone, Samsung Blackjack, which had synched very well with Outlook, and intended to synch the new...
Browsers & Mail
Missing boot menu and missing data partition
Hi there, I'm still very happy with my XP Pro, but I thought I'd set up a dual boot with Win7 ultima 64 and check it out. So I popped in another hdd that was sitting idly in a drawer and installed 7 on it. I fully expected that Win7 would be able to see there's an XP installation and create a...
Installation & Setup
about 10GB missing data
my C drive properties reports used space 31.4 GB Free space 37.7 GB Capacity 69.2 GB but when i go into (C:) the folders i get are ATI 100MB MSOCache 0 bytes Perflogs 0 bytes program files 917 MB
General Discussion
Activ synch problems
Hi Anyone know how to get activ synch on windows 7 for older PDA's. I have a Ipaq 2210 running windows pc2003 version, i can't download Windows mobile device centre, as it only takes the newer windows mobile software, i cant use activ synch 4.5 as it does not run on win 7 so am stuck with no...
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 01:57.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App