#### Sliding dates on a graph?

```I have created stacked column graphs using the OFFSET function to
automatically update when each week's information is added to the worksheet.

However, now my boss want's only the last 4-6 weeks of information to be
displayed on the graph.  Is there a way to do this without manually changing
each data point (there are 6 for each week for each chart--YIKES) every
week?

Dee

```
 0
sperling (2)
3/21/2005 3:40:44 PM
excel.charting 18370 articles. 0 followers.

1 Replies
612 Views

Similar Articles

[PageSpeed] 52

```I found it!
http://www.peltiertech.com/Excel/Charts/DynamicLast12.html

"Dee Sperling" <sperling@infimed.com> wrote in message
news:uE\$hZxiLFHA.3064@TK2MSFTNGP12.phx.gbl...
> I have created stacked column graphs using the OFFSET function to
> automatically update when each week's information is added to the
worksheet.
>
> However, now my boss want's only the last 4-6 weeks of information to be
> displayed on the graph.  Is there a way to do this without manually
changing
> each data point (there are 6 for each week for each chart--YIKES) every
> week?
>
> Thank you for your time,
> Dee
>
>

```
 0
sperling (2)
3/21/2005 5:30:28 PM

Similar Artilces:

calculating hours into date format
hi I would like a formula that will allow a user to input a figure (hours and minutes) into a cell that will calculate the end date and time based on a start date and time. For example, Enter 30 hours, static start time is 01/01/04 00:00hrs, the formula would then calculate that the end figure is 02/01/04 06:00hrs. Essentially it is calculating the number of hours & mins added onto the start date with the end result a date and time later than the hours & mins entered Hope this makes sense! Hi in A1 put your date in B1 enter your hours in the format hh:mm C1: =A1+B1 and forma...

Date Navigator
I use Outlook 2002 ... this just started happening & I do not know what to do to resolve. Any assistance would be appreciated. In Date Navigator portion of Calendar, January 4, 2007 is bolded even though I have no appointments on that day? How can I get this date unbolded? Thank you - EJS ...

Insert date en time with onchange function
Hi, I have a ntext field in a service indenity . When it is edited i want automaticly insert date en time. Can anyone help? Kind regards Maarten Kievit You may review this website on using Javascript to get time. http://www.tizag.com/javascriptT/javascriptdate.php In your onChange event for that field, you may add var currentTime =3D new Date() var month =3D currentTime.getMonth() + 1 var day =3D currentTime.getDate() var year =3D currentTime.getFullYear() crmForm.all.[Your Field].DataValue =3D month + "/" + day + "/" + year; hope this helps. Darren Liu, Microso...

Timeline Graph
Hello, I am trying to make a timeline in excel but it's giving me some trouble. I concluded the best graph type to use was floating bars as they have a start position and a lengh. This is fine for dates of say: -100 to -50 and 100 to 150 but excel can't seem to handle going over the origin point, it won't draw -100 to 100. I'm just trying to do a basic rise and fall of different civilisations, can anyone help? Thanks. You could increase all the values by the lowest negative number, and create a chart from the adjusted numbers. For example, if -100 is the earliest year, inc...

Hi friends, I have a problem, in a macro I need to calculate a date adding working days only. This add not include saturday / sundays and holidays. For example: 21/5 + 6 days = 31/5 How i can to do ? Thanks in advance and sorry by my english, Christian For adding days, use the DateAdd function. It won't return an invalid date like 31/5. The Weekday function returns the number of the day, for instance this Weekday("22.05.2010" ,vbUseSystemDayOfWeek) returns 6 for Saturday, tomorrow it will return 7 for Sunday. For holidays I can't help...

Lookup for oldest date among different dates
Hi all, I badly need your help in the below formula Example: Structure : Account includes Sub-accounts and each sub-account includes dials Formula : Account activation date = Oldest Sub-account activation date where there is more than one account and hence different activation date for each account and in turn the sub-accounts that belong to each account Below the example A B C D Account # Sub-Account # Account Sub-account activation activation ...

date is in 20010129 format, how can I get it in m/d/y format
-- jsanders Data>text to column, go to step three and select date and YMD and for future posts it's considered rude just using the subject line Regards, Peo Sjoblom With the value 20010129 in cell A1, enter this formula in B1: =DATEVALUE(MID(A1,5,2)&"/"&RIGHT(A1,2)&"/"&LEFT(A1,4)) and the format the cell as a date. The various functions parse the 20010129 string into its components, and the DATEVALUE converts that string to a datevalue that Excel can recognize. ...

How to create a calendar from date information in XL sheet.
I have an XL spreadsheet that contains multiple columns, one of which contains data in date & time format. Is there a way to export this data and associated information from the record to another application, for example Word, and create a calendar? Any suggestions how to manipulate this XL data are welcomed. Thanks! ...

Bar Graphs #5
Hi all, I have set-up a bar-graph consisting of four horizontal bars. I would like to overlay one particular bar onto another specific bar - leaving the other two as is. Is this possible? I have looked at the 'Overlap' option but unfortunately while this is on the right theme, it overlaps everything! Any help greatly appreciated! On Tue, 12 Jun 2007, in microsoft.public.excel.charting, Don <Don@discussions.microsoft.com> said: >I have set-up a bar-graph consisting of four horizontal bars. I would like >to overlay one particular bar onto another specific bar - leaving ...

x/y axis graph
i need to do an x/y axis graph, but my y axis must be alphabetical not numerical , how do i do that. please help ...

Current Date 01-20-10
I would like to filter on todays date. What is the field name for the current date. Thanks. Harry Try "Current Date." - Andrew Lavinsky Blog: http://blogs.catapultsystems.com/epm > I would like to filter on todays date. What is the field name for the > current date. Thanks. > > Harry > ...

counting dates #2
in cells D & E i have a series of dates. I want to put a formular E - D = calculated number of days and i also dont want it calculating weekend? the purpose of this is excel to work out how many days it takes to serve a document is this possible and if so what is the formular please =NETWORKDAYS(Start_date,End_date,holidays) Holidays would be a range containing the dates of public holidays you wish to de excluded from your calculation. for example in your case, if you entered the range of holiday dates in cells H1:H10 =NETWORKDAYS(D1,E1,H1:H10) -- Regards Roger Govier "jenn...

Hide Alternate Labels on Date Axis
Hi, I'm having trouble trying to hide every other label along a horizontal date axis. I start on the 01-Jan up to 10-Jan and through using the 'Format Axis'->'Scale'->'Major Unit' and setting this to 2 I can hide the labels: '02-Jan'; '04-Jan'; etc. However, I want to hide the odd dates: '01-Jan'; '03-Jan'; etc. I have tried the various combinations with the dialog box but can't get anything to work. Should I be using a custom formula or something? Any help is much appreciated. Paul. In article <1168177092.892944...

help with line graph
i accidently and unknowingly tuned off the line on my line graph, when i try to do the line graph the line isn't there. please help!!!!!!!!! Can you see the markers on the chart? If so right click one, select Format Data Series; on the Pattern tab put check mark next to Line If you cannot see it; click on chart, tap up/down arrows watching Name box, when Series 1 show up, use menu item Format. -- Bernard Liengme www.stfx.ca/people/bliengme remove CAPS in e-mail address "darci" <anonymous@discussions.microsoft.com> wrote in message news:149a201c3f8f9\$4cf70c70\$a601280a@...

Subtracting minutes from a date
Is there a way to subtract 15000 minutes from todays date and show the results in date format. A1 = todays date b1= #minutes c1= A1-b1 (the date that many minutes ago) =A1-(B1/(24*60)) Format as Date -- Kind Regards, Niek Otten Microsoft MVP - Excel "J. T. SYLVESTER SR." <sylvester1501@peoplepc.com> wrote in message news:663e99ad.0410011045.29cd532b@posting.google.com... > Is there a way to subtract 15000 minutes from todays date and show the > results in date format. > A1 = todays date > b1= #minutes > c1= A1-b1 (the date that many minutes ago) Su...

Multiple date validation in a single cell
I am trying to do a rather complicated validation (I think it i anyway!) I want to allow ONLY dates of a particular format to be entered int the one cell - i.e. YYYY OR mm/YYYY OR dd/mm/YYYY For example, the same cell can have either one of these format entered, but MUST match one of them to be accepted. 1970 is OK and is captured in the cell as 1970 (not 1/01/1970) 70 is assumed to mean 1970 on entry 05/1970 is OK, captured in the cell as 05/1970 (not 1/05/1970) 5/70 or May-70 is assumed to mean 05/0970 on entry 05/06/2004 is OK 5/6/04 or 5 June 04 is assumed to mean 05/06/2004 on entr...

Another question regarding Dates..
First, thanks to the replies to my previous post. How can I work out the day & month when I only know the Year and Day Number? Ie Year = 2004 day number = 302 The answer I'm looking for is 28/10/2004 Again, taking into consideration the leap years Thanks again in advance =DATE(2004,1,302) Regards, Peo Sjoblom "Anthony Slater" wrote: > First, thanks to the replies to my previous post. > > How can I work out the day & month when I only know the Year and Day Number? > > Ie > > Year = 2004 > day number = 302 > > The answer I'...

Date an time on WinXP.
Does anyone know where windows Xp gets the time and date it displays from? My system date and time often fails, resulting in the time beiing 5-5mn delayed compared to what it shoul have been . I wonder what can cause that???? ...

how do I stop Excel taking decimal fractions as dates?
sometimes when I enter decimal fractions Excel thinks this is a date. How do I stop this? Hi Insert a single quote before the fraction '3/4 The quote will not show up in the cell, but it will tell Excel to treat the cell as Text. Alternatively, Format>Cells>Number>Fractions 3/4 will display as 3/4 but will be stored as 0.75 and can be used in further calculations. -- Regards Roger Govier "aa" <A@aa.com> wrote in message news:efV2MhV9GHA.4376@TK2MSFTNGP03.phx.gbl... > sometimes when I enter decimal fractions Excel thinks this is a date. > How do ...

i need monthly ledger that is catagorized by payment due dates
"j.marie" <j.marie@discussions.microsoft.com> wrote in message news:9C223E6B-0C7C-46AA-BEAE-2B49F97D4949@microsoft.com... > Nothing. PLEASE write your question in the body of the post, not in the subject line. This is not a chatroom. Thankyou. In answer to your question, you would be better advised to buy an inexpensive dedicated accounting package. That will do what you want "out of the box". ...

Remove time portion from date on Excel 2007 chart
I am trying to remove the auto generated time of 00:00 to every date in my chart. I have tried setting the format, but it just ignores whatever I try to input. Any help would be appreciated. Where does this appear? Which labels? - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ NeoFax wrote: > I am trying to remove the auto generated time of 00:00 to every date > in my chart. I have tried setting the format, but it just ignores > whatever I try to input. Any help would be appreciated. ...

date time problem
I would like to have a date cell that can have an input mask of __/__/__ so that a user need only enter the numerics of a given date; i.e 052405. I I tried setting the cell format to custom mm/dd/yy and I get a return date of 10/1/43 !!!!!???? Why has excel lost the correct date? Regions global show the correct year range, and Excel is set to 1900 time? What do I need to do to correct this? Thanks XL's parse engine and display engine are separate - the displayed format has nothing to do with how the entry is parsed (other than Text entries are not parsed at all). For a workaro...

Date format 03-03-08
How do I get a date to print as mm-dd-yy in a field? On Sun, 02 Mar 2008 23:43:02 -0500, BC wrote: > How do I get a date to print as mm-dd-yy in a field? Set the format property of the Date control to: mm-dd-yy -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail ...

Appending or Up-dating a formula
I am using an =Ave function in a formula to average quite a few cell values together. I add new information all the time; sometimes 5 or 6 new cells at a time. How can I append or up-date my formula to include these new cells with out have to type the new cells into the formula? When I make the cell that has the formula in it active/edit, all of the cells that are referenced in the formula have a highlight around them. Is there a key or key combination I can press while clicking on the cells I want to add to the formula? Thanks, john Hi see your post in Excel.misc -- Regards Frank ...

date format into day of week
I have column in excel which show date in format 2009-08-21. Is it possible in new column to get day of week from this data? Is this what you are looking for? -- Rick (MVP - Excel) "Steve" <Steve@ggmmaaiill.com> wrote in message news:euX0IfIJKHA.3928@TK2MSFTNGP04.phx.gbl... >I have column in excel which show date in format 2009-08-21. Is it possible >in new column to get day of week from this data? > > > Is this what you are looking for? =TEXT(A1,"dddd") -- Rick (MVP - Excel) "Steve" <Steve@ggmmaaiill.com> wrote in me...