scatter plots

Hi, I have a question regarding a way to organize many scatter plots 'easily'. I am working on improving it to handle different time series and have not found a simple way for it to auto-update yet. let's say I would like to compare 500 time series that look something like this...

I need a scatter plot that will leave out any values at 0

so i have <tbody> x y 1 2.72*10^(-7) 2 2.04*10^(-7) 3 1.51*10^(-7) 4 1.12*10^(-7) 5 7.9*10^(-8) 6 5.23*10^(-8) 7 3.21*10^(-8) 8 1.85*10^(-8) 9 9.74*10^(-9) 10 4.19*10^(-9) 11 1.10*10^(-9) 12 9.78*10^(-11) 13 1.88*10^(-12) 14 9.59*10^(-16) </tbody> for data and...

Helloooo to the masses of fellow coders, After hours of pouring over the world wide web looking for sample code that might be able to accomplish the title of this post, i've come up empty handed. What i'm attempting is to create a vba routine that can take a subset of data Ex: X...

I am trying to set up "empty" scatter plots that display counts on various dates when cells are populated with data. When I select the date x-axis data it appears to the side of the Edit Series dialog box and the Select Data Source dialog box as dates, but the graph displays generic...