Greetings,
I'm using VBA to create over 200 hydrographs of water levels in monitoring wells. One seriescollection is continuous data (1 hour intervals by datalogger) and the other series is a manual measurement (about 4 times a year). I want the manual measurements to be interpolated so that a line connects the gaps between them, But I don't want the continuous data to interpolate gaps (i.e., when the data logger stopped recording).
It seems the "DisplayBlanksAs " is a property of the chart, but cannot vary between series. Any idea how to do this? I've started thinking of overlaying two chart objects on the same worksheet, but that seems kind of kludgy.
Any help would be appreciated!
Jon Mulder
Durham, CA USA
can you a workbook post example of your data layout and chart.
It could be that NA() formula can be used to interpolate.
pulling up a chair ...
save you sitting there all day teylyn here is what I had in mind.
Obviously Jon if your chart data is structured differently post a workbook.
<head-desk>
Exploit the old N/A!! True mastery in action.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks