MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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 ...........;)

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


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.