Link to home
Start Free TrialLog in
Avatar of RamzyNEbeid
RamzyNEbeidFlag for Egypt

asked on

Excel 2010 and More Charts Reports

Dear all
I started to work with Microsoft Analysis Services and I am using Excel 2010 as my reporting tool.
Everything is working fine, my question is there any more charts that I can get and add it inside excel so it will give me more beautiful reports.
Thanks,
SOLUTION
Avatar of hintco
hintco

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of RamzyNEbeid

ASKER

i am looking for animated Charts
Avatar of Ingeborg Hawighorst (Microsoft MVP / EE MVE)
What do you want to animate? Or better: Why do you want to animate? Does the animation help to understand the data, or will the animation be just decoration?



to be onset with you it is for more decoration and it makes the more beautiful
If the data does not speak for itself, then no amount of decoration will give you a better visualisation. Any glitz and animation will serve to distract from the data rather than enhance it, and that will not be in the best interest of the reader of the chart.

Can you explain in a few words what you would like to animate and why?
if i have a chart for Sales by Branches in year 2011

then i want to see 2010 i want the bars to move slowly so the user can feel it changing

this is what i meant by animation

thanks,
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
i tired them but, let me tell you that i am building all my charts from Cube

so it is not the same case with me + i dont have any experiance in VBA
all i know is C#

is there something ready?
The ExcelHero animated charts are the finest examples of creating animated charts with Excel. Since the macro language for Excel is VBA, that's what they're built on. If you have C# experience, it won't take you long to pick up VBA.

If you need a C# solution, the question is in the wrong zone. I doubt that you will find a ready-to-go C# tool, though.
i am sorry for late reply
i am looking for charts to be run on Excel an animated charts or more advanced charts

i need someone else rather than excel heroes

thanks,
I'm sorry, but I'm really not clear on what you want. You say you don't want VBA, but you want to animate Excel charts. You don't know VBA but you post in the Excel zone. You want to do it in C# but you don't post it in the C# zone and you don't mention C# until the third comment.  You want to animate Excel charts when the data changes but you don't want to do it the way the Excelhero example works. So what do you actually want?

It's easy to say "I don't want that".

Instead of dismissing all the suggestions posted here, you may now want to spend some time and describe your requirements in detail.

You need to be prepared, though, that the chances of finding the perfect solution for your specific situation without the need of some heavy adjusting are pretty slim.

Looking at your question again, maybe the only valid answer is: "No", unless you're prepared to look beyond your comfort zone.

cheers, teylyn
thanks,
i didnt dismiss all the suggestions posted here.

it is just that i am not the one who will do the job  everytime so the sales planning  team will do it and they are  not devlopers and they want to work with excel.
that's why i was looking for something ready that can be used.

thanks, and i apologize if i was not clear from the begning.
thanks,