Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

No OLAP Number Format in Pivot-Chart

Status
Not open for further replies.
Gauss

Gauss

Programmer
May 1, 2002
17
0
0
DE
Hello!

I have a pivottable with an OLAP-Source and a chartspace bound to the pivottable (OWC10/AS2000).
By using the UseProviderFormatting-property I retain the number format provided by the OLAP source in the pivottable. But when i set the HasValue-property of the chartspace-DataLabelsCollection-Object to true the OLAP-format of the values presented in the chart is lost.
Does anyone know how to force the chart to show values in OLAP number format?

Regards,
Gauss
 
Sort by date Sort by votes
Someone said upgrade to XP - thats my thinking too.
Or is this posted after your previous posting? Either way to check it out I'd need to know what Excel version you're on...
 
Upvote 0 Downvote
Hi netDev007.

It's OfficeXP (Office Web-Components 10).

Regards,
Gauss
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

vktrez
  • Locked
  • Question
Best OLAP Tools 1
Replies
1
Views
127
fominlena
fominlena
dcern
  • Locked
  • Question
Ingres ODBC Driver slow
Replies
0
Views
119
dcern
dcern
Vary88
  • Locked
  • Question
Both One-Many and Many-One relations in fact table
Replies
0
Views
114
Vary88
Vary88
MDGarcia
  • Locked
  • Question
ODBC error: Specified driver could not be loaded due to system error 193
Replies
1
Views
177
k5tm
k5tm
Malbordio
  • Locked
  • Question
ODBC in PHP to connect to ServiceNow
Replies
1
Views
150
k5tm
k5tm

Part and Inventory Search

Sponsor

Back
Top