relative reference graph

[Guest]

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

 

[Guest]

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-applications-and-spreadsheet-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 table>click Refresh) before the chart will reflect the new data.

God Bless

Frank Pytel