hi,
i have started using the dynamic chart as described here
http://peltiertech.com/Excel/Charts/DynamicLast12.html
i have changed it and gone up to 24 and 8 columns.
But i would also like that same info that gets charted to show in other cells as the month and numbers itself.
for example
if the last 12 entries are charted then i would like the same last 12 entries shown in a list on another page (not charted just listed in rows and columns) and when a new entry would be put in not only the chart would update, but the list would update also.
Thank you very much
Mr. Chan
Bookmarks