Doesn’t seem right but then try my suggestion with this change to always start
at row 8
months
=OFFSET(INDIRECT("$A$" & 8),0,0,13,1)
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Steve Weaver
Sent: Saturday, November 19, 2011 9:14 AM
To: excel-macros@googlegroups.com
Cc: Sam Mathai Chacko
Subject: Re: $$Excel-Macros$$ Making Chart more useful to readers
Sam,
Currently each week we insert a new row for week number 1 (row 8) and manually
insert the new data. Than we adjust the table to reflect the proper week number
for the previous weeks. Once that is finished, we change the chart to select
the proper time frame Weeks 1 thru 13.
I'd like to show the chart in the most meaningful way possible. If that means
making the chart look differently, I'm open to that suggestion.
Hope this helps!
Thanks!
Steve
--------------------------------------------------------------------------------
On 11/19/2011 8:25 AM, Sam Mathai Chacko wrote:
To suggest a suitable solution, you will have to clearly mention how your
weekly data gets input. As of now, it is not clear how a new set of data is
added to your table.
From the attached file, can you confirm if that is how you want the charts to
look like
Regards,
Sam Mathai Chacko
On Sat, Nov 19, 2011 at 6:15 PM, Steve Weaver <steveweave...@comcast.net>
wrote:
Hi all,
I would like to change the attached spreadsheet to allow for easier weekly
updates and to provide the readers with a little more useful information. To
accomplish this I would like to do the following:
a.. make the rolling 13 week data dynamic so that when the current weeks
information is added it will automatically use only the most recent 13 weeks of
data
a.. on the chart showing the Order Bookings ($), split each weekly total
between the inside and outside bookings
Thank you in advance for your help.
Steve
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
