View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
LINDA LINDA is offline
external usenet poster
 
Posts: 205
Default how to create a chart from a dynamic table of data?

hai!!
i need to create a chart from a dynamic table,meaning that the table is
auto-generated from database after clicking a button.This is my first time
using macro in excel, so i'm not really well in it.
my idea right now is using Chart.Add,but then i'm having problem on how to
define the cells selection(i must do "the do..loop statement" rite?)
ur help is very appreciated,tq!