match range of axes from one plot to another

Y

yo

My spreadsheet has about 4 plots in different sheets and i wanted to combine
these charts into one sheet with new formatting. I matched up the data using:
Sheets("For Paper").ChartObjects("Chart 1").Chart.SeriesCollection(1).Formula
= Sheets("Chart4").SeriesCollection(1).Formula

Now I want to include in my macro a way to match the range of the x and y
axes. On my original plot, one of the plottted series is a 45 degree line
that extends from the minimum of x and y to the maximum of x and y. I was
thinking of possibly referring to the array from xvalues and pulling the
first value and second value to be linemin and linemax, but i'm not sure how
to do it. any ideas?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

plot excel chart against datetime 0
Specifying which axes Excel uses to plot a graph 0
Putting the series 1 and series 2 titles from a worksheet 0
For Eachcell in Range tranpose comma seperated values to a list in D 4
.Seriescolection(n).formula - size limitation? 5
Range passed to a function - trying to just move through the range 4
Automatically sending multiple parts of text from one word doc to another - is possible. 0
how to plot a chart with 3 axes? 13

Top