Chart Types

R

Razvan

Is it possible to check if a pivot table generates a valid chart of a certain
type? Some data and facts put into a ScatterLine chart, let's say, cannot be
represented in this form.
 
A

Alvin Bruney [MVP]

Yes, the pivot table contains a chart object that represents the live chart
object. You can interogate that object as needed.

--
Regards,
Alvin Bruney
------------------------------------------------------
Shameless author plug
Excel Services for .NET is coming...
OWC Black book on Amazon and
www.lulu.com/owc
Professional VSTO 2005 - Wrox/Wiley
 
R

Razvan

ok, so what should i interogate for, if you can be as explicit as possible,
thank you
 
A

Alvin Bruney [MVP]

Get a reference to the chart object and ask it for its type. It should
return an object of type object. You will need to cast that to an enum chart
object to determine the type. I swear there is code like this in here if you
google you should find it.

--
Regards,
Alvin Bruney
------------------------------------------------------
Shameless author plug
Excel Services for .NET is coming...
OWC Black book on Amazon and
www.lulu.com/owc
Professional VSTO 2005 - Wrox/Wiley
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtered view of Visio Chart 0
Doughnut Chart linked with the slicer in the pivot table 0
Create a chart from a table in word thats dynamic 0
Move Chart with Text 0
Creating a Chart on form from selected data in query. 0
Some chart types cannot be combined... 1
How I can set dynamic pivot table ONLY when I have enough data point 1
HIDE VALUE 0 FROM CHART 1

Top