You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@poi.apache.org by Jeff Lynn <jm...@yahoo.com> on 2005/12/12 22:57:36 UTC

How do you refresh charting worksheet?

 Hi, 

Will someone help by showing me some examples of how to refresh worksheet consists of a chart object that uses data from the first worksheet? 

I was unable to figure out how to update the chart worksheet so I created a Excel file with two worksheets.  First worksheet  is my data worksheet composed of two rows and two columns of x and y data.  My second worksheet composed of 1 single line chart with the chart definition of "=SERIES(Data!$B$1,Data!$A$1:$A$2,Data!$B$1:$B$2,1)". 

By inserting 10 rows of data between row 1 and row 2, I then remove row 1 and row 12expecting the chart to draw a line chart of the resulting row 1 and row 10.  But I was wrong.  The chart still draws only row 1 and row 2. 

How do I make Excel to refresh the charting sheet using POI? 

I repeat the same step using Exel program, it automatically update the charting object for me. 

Thanks for any suggestion! 

jml 


			
---------------------------------
Yahoo! Shopping
 Find Great Deals on Holiday Gifts at Yahoo! Shopping