I'm trying to get an excel chart to update in excel services when the pivot table that it is based on is drilled into. The chart updates in the Excel environment but not the excel services. Is this possible, and if so can someone please tell me how to do this?
TIA,
Grant
Thanks and Regards
Guruprasad Karnik
If i understand you correctly, and believe me, its possible i don't then recalculating the Excel web part containing the chart once i have drilled into the Pivot Table web part should update the chart and allow the drill down to be seen. I.e. when i drill into a year on the pivot table i get taken to Q1, Q2, Q3 and Q4. I'd like the given year on the chart to be drilled down to this level also.
This doesn't seem to work however. The chart remains the same as before the drilll down.
The cache Auto and Manual refresh are both set to 300.
Any further suggestions are welcomed.
Thanks,
Grant
You need to have both the PivotTable *and* the chart in the same web part for this to work.
Since each web part opens it's own session of the workbook, changes to one will not affect the other (if you have one web part displaying the pivot and another web part displaying the workbook). From your description I'm assuming you have them on separate parts correct?
The only way to do what you describe is having the same web part display both the Pivot and the Chart.
- Luis
Hi Luis,
I have just recieved the alert that an answer has been posted. Your answer looks as though it will certainly sort my problem. I do have one question though, How do i include multiple objects in the same web part?
Cheers,
Grant
Thanks
Guruprasad Karnik
Grant,
I am trying to have combination chart with a Bar & Line on Primrary axis and another Bar & line to Secondary axis
I am getting both the Line going the right way but my Bars are coming top of each other....Is there way to seprate the bars.
