Embedding a chart within a chart in Excel

Greetings,

I have been writing a macro that converts a bunch of data into a graph. There are multiple sets of data all plotted against minutes. There is also a data series that just switches between 1 and 0. I would also like to display this on the graph, but mixed in with all the other data, since is is not "real" data. I would like to display this binary signal on the top of the graph. I have included a picture of what I would like it to look like. The picture that is included was the graph that I have already generated and then just pasted the oscillating signal on top of the graph with MS Paint. I would love to know how to do this from within excel.

Any help would be appreciated.

Kind Regards,
Willis
embeddedd graph.jpg

Well the only reason I did not want to do that is because then it is plotted among the other data. If there was a way for me to shift that data all the way to the top I suppose that would work too.

-Willis

That is a good idea. I didn't even think about it. Thanks.

You seem well versed in excel so I have another quick question for you. If I am using a macro to auto-generate a graph, how can I make it so that the macro works for any range of data, whether there are 10 or 500 entries.

This is an example data series that I have now.

ActiveChart.SeriesCollection(1).Name = "=""Power"""
ActiveChart.SeriesCollection(1).Values = "=' Data '!$K$2:$K$1297"

Is it possible to modify this to autorange the data?

Thanks alot,
Willis