graphing data based on todays date
 

I am trying to create a graph that will automatically update itself based on
todays date. For instance i would like to graph data from the past 28 days
only starting from todays date. however every day i have to go into the
chart and reselect the source data because it is constantly changing on a day
to day basis. Is there a way to do automatically update this. or a formula
that i can put into the source data using todays date?

graphing data based on todays date
 

You can do it using dynamic charting. First, we need to setup the 29 cells
you'll use for the x-axis. In the first one, input:
=TODAY()
In the next, something like
=A1-1
and copy down the appropriate amount of cells. Now, go to Insert - Name -
Define. Give the range a name, like MyRange (no spaces). In the referes to
section, define the cells your just created:
=A1:A29
Click Add, then ok.

Now, go to your chart - Source data. For the x-axis, input something like
this:
='My Workbook Name.xls'!MyRange
Click ok.

Your chart will now update itself based on the formula cells!
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Soccerboy83" wrote:

I am trying to create a graph that will automatically update itself based on
todays date. For instance i would like to graph data from the past 28 days
only starting from todays date. however every day i have to go into the
chart and reselect the source data because it is constantly changing on a day
to day basis. Is there a way to do automatically update this. or a formula
that i can put into the source data using todays date?

graphing data based on todays date
 

For a more detailed look at dynamic charting (and probably a clearer answer
to your question) see Jon Peltier's site:

http://peltiertech.com/Excel/Charts/Dynamics.html
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Luke M" wrote:

You can do it using dynamic charting. First, we need to setup the 29 cells
you'll use for the x-axis. In the first one, input:
=TODAY()
In the next, something like
=A1-1
and copy down the appropriate amount of cells. Now, go to Insert - Name -
Define. Give the range a name, like MyRange (no spaces). In the referes to
section, define the cells your just created:
=A1:A29
Click Add, then ok.

Now, go to your chart - Source data. For the x-axis, input something like
this:
='My Workbook Name.xls'!MyRange
Click ok.

Your chart will now update itself based on the formula cells!
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Soccerboy83" wrote:

I am trying to create a graph that will automatically update itself based on
todays date. For instance i would like to graph data from the past 28 days
only starting from todays date. however every day i have to go into the
chart and reselect the source data because it is constantly changing on a day
to day basis. Is there a way to do automatically update this. or a formula
that i can put into the source data using todays date?

graphing data based on todays date
 

Excel 2007 PivotTable, PivotChart
Chart scales automatically with changes in source data.
Source data range is dynamic.
This example counts -20 working days from today.
http://www.mediafire.com/file/1nytwn...06_08_09a.xlsx