Hi Reporting Gurus,
I have Bex output data on Excel as shown below.
<b>Projects</b> P1 P2 P3 P4 P5 P6 ........(it may grow dynamically row-wise)
<b>%completed</b>
<b>(DEC 2006)</b> 10 8 20 30 60 70.........(it may grow dynamically row-wise)
<b> (NOV 2006</b>) 8 9 4 20 40 90.........
<b>(OCT 2006)</b> 20 10 5 23 33 33.......
<b>(SEP 2006)</b> ......................................
Now I have a created an Excel chart on the current month data ie (Project Vs DEC 2006).
But as Projects will be added in future ,those projects have to get reflected in the chart dynamically only for the current month data.
I tried to use Bex charts but all the datas(for all months) are coming ,which makes my chart messy.
So i tried to use Excel chart,but i dont know how to dynamically capture the project values if they are added in future.
can someone throw light on my problem.
should i write any VB macro code to achieve this?
Any kinda help is appreciated.
Thanks in Advance,
Have a nice day,
Regards
Sam Mathew