pivot chart issue

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, all. currently i'm using the pivot table to populate my data using OLAP, so i'm intend to add a chart above the the table , which will showing the same thing as the table show,so whenever i select a record, the chart should change at the same time. until now i still looking for the sample of it, so is there any sample that i may refer to?Thanks
 
There is a section on Pivot Tables and Charts on my web site,
contributed by MVP Debra Dalgleish:

http://peltiertech.com/Excel/Pivots/pivotstart.htm

To experiment, make yourself a table of values, with field names in the
top row, and values for each in the records (rows) below. A pivot chart
is not my favorite tool, but it's simple enough once you know a little
bit about pivot tables. A pivot chart by default is created on its own
sheet. To put it above your pivot table, right click on the chart,
choose Location from the pop up menu, choose As Object In, and select
the name of the sheet with the pivot table. Switch to that sheet, and
move and resize the chart to fit.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Jon, thanks for your help and it really help me a lot. unfortunately i have missed out part of the question on the first post, that is i decide to add the pivot table as a component using the OWC into my web based page, so what happen is i want to know if i want to add a pivot chart would it be the same thing as i done in excel ? since i just put the pivot table as a component in my page using visual studio .net, is it possible be done?Thanks
 
Unfortunately I have no expertise using the office web components. A
quick search of Microsoft's site suggest these pages as possible sources
of answers:

http://msdn.microsoft.com/msdnmag/issues/03/10/OLAP/default.aspx
http://msdn.microsoft.com/library/en-us/dnowc/html/odc_bip.asp
http://msdn.microsoft.com/library/en-us/dnoffsol02/html/odc_PivotingTablesParti.asp

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top