Charts Issue

  • Thread starter Sanjeev Srigiri
  • Start date
S

Sanjeev Srigiri

Hi Group,
can somebody post a code which shows me how i can bind chart to a pivot.

I mean the setdata statement and not the below statement
Chartspace1.datasource = PivotTable1

I am not able to get the XAxis of Scatterlinechart type filled with the
dimension from the
PivotTable.

Please help

Thanks in Advance
Sanjeev
 
A

Alvin Bruney

The setdata stuff comes after you set the data source.

so after that line you would need a
Chartspace1.Type = constants1.scatterline blah blah blah

then you call the setdata to bind the dimensions

Chartspace1.setdata constants1.chDimSeriesNames, 0, constants.chPivotColumns
followed by chPivotRows to bind rows and columns

hth
 

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

a problem about chartSpace's XMLData 1
Help Binding Spreadsheet to PivotTable control 1
Chartspace & Excel2003 0
How do you get a field into the data area of a Chart? 1
Removing a measure from a Chart 0
Autoscaling date or time on X-Axis of line chart 2
Changing/Editing Series Captions 0
Multiple Scatter Lines Series in a Chart. 0

Top