Dynamic Graph which Changes automaticaly when a range is Cus

[kahmad]

Dear All,

Is it Possible to Have a Dynamic Graph which will change if the Data is Filtered , lets say by using custom Filters.
e.g in a range of data i need to custom filter using dates i.e => 01/01/01 and =< 15/04/01.

Please help.

Edit (JPG): Huge HTML table.
This message was edited by Juan Pablo G. on 2002-09-20 16:08

 

[IML]

Excel only graphs visable cells, so your graph should change automatically when the filter is applied. Sorry if i am misunderstanding the question.

Good luck

 

[IML]

I swear I just hit reply and not quote on the last one. Maybe not. Here it is again:

Excel only graphs visable cells, so your graph should change automatically when the filter is applied. Sorry if i am misunderstanding the question.

Good luck

 

[Mark W.]

Use a PivotTable to summarize your data, and chart from it.

 

[kahmad]

Thanks,
I tried this with a Pivot Table, but the Problem is that every time the Pivot table is Refreshed the Graph changes back to the Default Bar graph.

Where as i need a graph with different values on the primary and the secondary axis.
One as a line grapg and other as a Bar gragh.

Any help on How to keep the Formatting when the Pivot table is Refreshed.

I know this can be done with a Macro, but unfortunately my VAB skills are zero.

Thanks

_________________
This message was edited by kahmad on 2002-09-21 03:23