relative reference graph
 

Hi
How to make the graph relative in the worksheet. I have some columns of
data and next to that is the graph at row 2-60. When I run a macro to list
data for example row 100 to row 200, my graph disappear. How to make it
relative so I can see the graph no matter what data colimn jump to different
area?
Thanks
Daniel

relative reference graph
 

Daniel;

I would run your data through a pivot table and then create the graph from
there. You can see an example here (file named Man Hour Revenue Chart.xls).

http://groups.google.com/group/excel...et-programming

You can select and deselect all the data you want. Only thing I don't like
is that you must refresh the pivot table (right click on any sell in the
pivot tableclick Refresh) before the chart will reflect the new data.

God Bless

Frank Pytel
"Daniel" wrote:

Hi
How to make the graph relative in the worksheet. I have some columns of
data and next to that is the graph at row 2-60. When I run a macro to list
data for example row 100 to row 200, my graph disappear. How to make it
relative so I can see the graph no matter what data colimn jump to different
area?
Thanks
Daniel