Thank you Sam and Don for sharing your knowledge.
You guys are GREAT!
Steve
On 11/19/2011 1:13 PM, Sam Mathai Chacko wrote:
For some reason, the named range with an INDIRECT formula isn't
getting accepted within the chart. Had to change the formula to
=OFFSET($A$7,1,0,13,1), assuming row 7 or any row above will not be
deleted or inserted, since OP mentioned that they always insert new
data in Row 8
Have put in the dynamic names as Don suggested. You can have a look at
the attachment Steve.
Regards,
Sam Mathai Chacko
On Sat, Nov 19, 2011 at 9:05 PM, dguillett1 <dguille...@gmail.com
<mailto:dguille...@gmail.com>> wrote:
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 <mailto:dguille...@gmail.com>
*From:* Steve Weaver <mailto:steveweave...@comcast.net>
*Sent:* Saturday, November 19, 2011 9:14 AM
*To:* excel-macros@googlegroups.com
<mailto:excel-macros@googlegroups.com>
*Cc:* Sam Mathai Chacko <mailto:samde...@gmail.com>
*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 <mailto: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:
* 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
* 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
<mailto: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
