dbTalk Databases Forums  

Statistical charts and MS OLAP

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Statistical charts and MS OLAP in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Sunil Kadimdiwan
 
Posts: n/a

Default Statistical charts and MS OLAP - 01-19-2004 , 08:21 AM






I like to create histograms, box charts etc. using MS OLAP cubes.

As I know Excel 2003/OWC 2003 does NOT offer these features. How can I get this functionality? 3rd party products/add-on recommendations would be helpful too

Thanks in advance

Suni


Reply With Quote
  #2  
Old   
Eric Bowden
 
Posts: n/a

Default Re: Statistical charts and MS OLAP - 01-19-2004 , 04:45 PM






You can do it with VBA within Excel. I copied the data from pivot tables
using a simple macro, then created various histograms and other reports
using VBA code.... There may be an easier way, but I have not found one.



"Sunil Kadimdiwan" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:
I like to create histograms, box charts etc. using MS OLAP cubes.

As I know Excel 2003/OWC 2003 does NOT offer these features. How can I get
this functionality? 3rd party products/add-on recommendations would be
helpful too.
Quote:
Thanks in advance.

Sunil




Reply With Quote
  #3  
Old   
uswine
 
Posts: n/a

Default Re: Statistical charts and MS OLAP - 01-24-2004 , 12:01 AM



Try charting in Access 2003 .... it is significantly better than excell ....
our use the office 11 pivot table service in your application.

"Eric Bowden" <ehbowden (AT) yahoo (DOT) com> wrote

Quote:
You can do it with VBA within Excel. I copied the data from pivot tables
using a simple macro, then created various histograms and other reports
using VBA code.... There may be an easier way, but I have not found one.



"Sunil Kadimdiwan" <anonymous (AT) discussions (DOT) microsoft.com> wrote in message
news:769BD53E-AEDA-45E9-BB13-E6B4F7144747 (AT) microsoft (DOT) com...
I like to create histograms, box charts etc. using MS OLAP cubes.

As I know Excel 2003/OWC 2003 does NOT offer these features. How can I
get
this functionality? 3rd party products/add-on recommendations would be
helpful too.

Thanks in advance.

Sunil






Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.