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 with dynamic data

Posted by Windall Bekker on January 08, 2002 10:08 PM

Hi everyone,

Does anyone know how to create a chart that will automatically adjust to different data. eg:

Day 1 has 5 records
day 2 has 10 records
day 3 has 2 records

I want the chart to show 5 records only on day1, then automatically adjust to show 10 records only on day 2 and 2 records only on day 3

I was hoping to use the "Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select" command in the graph data range but have not been successful so if you can help ...........;)

Re: Chart with dynamic data

Posted by Bariloche on January 08, 2002 10:25 PM

Windall,

Check out the "Dynamic Charts" link (in the left-hand frame) at Tushar Mehta's page. He has a number of examples of ways to do this.

Hopefully one will fulfill your needs.

enjoy

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.