Archive of Mr Excel Message Board

Check out Bill's new book on Charts and Graphs for Microsoft Office Excel 2007

Back to Charting for Excel archive index
Back to archive home

Chart Range

Posted by David on June 30, 2000 6:08 AM
Is there any way to use column number to provide a range?
All right now to explain that question.

When you change the range of a graph you need a range right?
well I have a Loop that searches for a number then i have the coordinates of the bottom left side of the range.
Then the opposite corner is a variable distance of rows up and one column over.
Are you following.

And the second stupid question is what is up with "mr. excel" This page takes way too long to load. I love to be able to look back over the old responses but maybe they could be on a separate page. Takes way too long to load and my computer is pretty fast.

Well Thanks for listening


Re: Chart Range

Posted by David on July 02, 0100 11:04 PM

ActiveChart.SetSourceData Source:=Range(.Cells((Rownumber-Numbers), Columnnumb), .Cells(Rownumber, (Columnnumb + 1))), PlotBy _
:=xlColumns

Thanks anyway


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.