Question:
Hi,
I am encountiring problem while generating graphs/charts in BEx.
I have to capture 4 key figure values to generate a graph.
I written a macro which is running perfect & generating graph also.
But the problem is as and when drilling down on different characteristics then graph is executing with wrong measurements.
What i found from that is the macro that written for fixed columns range
Eg: G36,H36,I36,J36.
If i do any drilldowns on different chars then graph goes wrong.
Columns will get add and it is becoming
Eg: K36,L36,M36,N36....like that.
so here irrespctive of the drill downs i have to generate a graph because user may drill down on 6 chars first and then deselect 3 out of them later they may drill it down on only 2 or 8 or not specific.
Without depending on the drill downs is there any way to capture only those 4 values.
Regards
Giri
_________________
All the best
Answer:
why did you write a macro? adding a chart is standard functionality... and it works on the entire result area
so, if you drill-down, your chart is automatically updated (whether it makes sense or not)
cheers,
El Belgio
Answer:
Hi,
User is expecting graphs when ever the query is refreshing/executing. and wants to dispaly graphs along with query results.
So we are picking up only 4 summerized values out of 9(Keyfigure values).
User wants only Stacked Column Graph with few other things.
So that is the reason i have written macro.
_________________
All the best
Answer:
So change the Global references to the cells (i.e. the K36, ....) by relative references. use search function to find column number for each KF, ...
I can provide (if I find it back) some code on this.
_________________
When my car stops, I first look at the gasoline's level before dismounting the engine.
Tuly Idiot's fan club active member.
Answer:
Hi Fred
Thank you for the information.
I did not think really about the one which u explained.
Definately i will try with reference freature in excel.
Regards
Giri Babu
Answer:
Hi,
User is expecting graphs when ever the query is refreshing/executing. and wants to dispaly graphs along with query results.
So we are picking up only 4 summerized values out of 9(Keyfigure values).
User wants only Stacked Column Graph with few other things.
So that is the reason i have written macro.
so, how about adding the same query with just your 4 KF's onto another sheet, set the chart on this one and hide the query results???
sounds way easier to me...