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
