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
