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
missing HP S2031 Series Wide LCD Monitor
i am not sure which forums this goes into, and cant find forum that is a monitor forum so i just went with drivers, anyway somehow my display device changed, i've looked EVERYWHERE, and couldn't find something, it's pretty weird how it changed. I'm stuck on - generic pnp monitor, i fixed that, but...
Graphic Cards
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
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
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 16:56.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App