Pros,
I’m writing data in to an excel spreadsheet and at the end need to set the chart (stacked bar) data to that of what I had just added to.
I add chronologically, so I’m keeping track of the last row and column – integer wise from activecell.row and .column.
So, now I need to set the series on the chart and the range business seems to think that I need (“A1:C12”) type of format and can’t even see where I can translate that.
I also can’t set each series individually because they are dynamic and based on a recordset from a query and I never know how many I’ll get. I have to use the range method.
Please help.
Respectfully,
Liz Ravenwood
Programmer / Analyst
B/E Aerospace | Super First Class Environments
1851 S Pantano Road | Tucson, Arizona 85710
Office +1.520.239.4808 | Internal 814-4808
beaerospace.com
Passion to Innovate. Power to Deliver
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar