I have a dynamic range of data that i need to put into a chart. I don't always know how many rows there will be and i need this chart to automatically generate. Is there a way to set the Data Range of a chart equal to a dynamic range of data. Also if anyone has any experience with creating or manipulating an Excel chart with Apache POI or another program like it, please let me know what you used as an API.
I can provide more information if this is unclear.
Rather than regurgitating other people's advice I'd recommend having a read through of Jon Peltier's site, more specifically:
http://peltiertech.com/Excel/Charts/...hartLinks.html
Re: Apache POI etc... not me I'm afraid
On a final note I have moved this thread to the Charting Forum.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks