| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Dynamic chart that displays a range starting today
I am trying to make a chart that updates automatically and only displays the
last 30 days of information starting at the current date. The data sheet for the chart is updated automatically, so there are future dates in the column. I hav tried the OFFSET and COUNTA route, but that fuction grabs data from the bottom of the data. I want the chart to start at the current date and go back 30 days. Can Anyone Help Me? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I combine a stacked bar chart with stacked colum chart? | Charts and Charting in Excel | |||
| Altering the range that is plotted by a chart via VBA | Charts and Charting in Excel | |||
| Dynamic Print Range Help | Excel Worksheet Functions | |||
| Dynamic charting problems (events) | Charts and Charting in Excel | |||
| named range refers to: in a chart | Excel Discussion (Misc queries) | |||
Threaded Mode
