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,
RamzyNEbeidAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

hintcoCommented:
Short Answer
Yes, there is additional charts template you can add to the Ms Excel 2010 to get more beautiful reports.
such as
- Excel 2007 / 2010 Flowchart Template
- Gantt Chart Template - Free Download for Excel 2007 and 2010
and others do some simple search in google some of them are free and others with charge..

0
RamzyNEbeidAuthor Commented:
i am looking for animated Charts
0
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
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?



0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

RamzyNEbeidAuthor Commented:
to be onset with you it is for more decoration and it makes the more beautiful
0
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
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?
0
RamzyNEbeidAuthor Commented:
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,
0
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
That is not out of the box functionality. You'd need some heavy VBA to get this to work. Excelhero has some working examples: http://www.excelhero.com/blog/2010/05/animated-business-chart.html

cheers, teylyn
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
RamzyNEbeidAuthor Commented:
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?
0
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
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.
0
RamzyNEbeidAuthor Commented:
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,
0
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
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
0
RamzyNEbeidAuthor Commented:
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,
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.