I need to create a Dynamic Chart (from a Dynamic Named Range in a Pivot Table) that plots the first 20 rows in the Range, but never more than 20. The Range will shrink or grow as it updates each month. If the Range has less than 21 rows, I need the chart series to show only the number of items as there are rows. If there are more than 20 rows, it must only plot the first 20 items (rows). I've created the Dynamic Chart, but I'm not sure how to limit the number of items being plotted in the chart series. Any suggestions would be appreciated.
This message was edited by RogerC on 2002-08-27 16:14
This message was edited by RogerC on 2002-08-27 16:15
This message was edited by RogerC on 2002-08-27 16:14
This message was edited by RogerC on 2002-08-27 16:15
