| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
automatically update chart plotting current month and previous 6
I need to automatically update a chart every month for a report but I only
want to plot the current month and six months back each time. For example Feb-Aug for the Aug report then for the Sept report plot Mar-Sept. Any suggestions? |
|
#2
|
|||
|
|||
|
This example shows how to plot the last 12 months. Perhaps you can adapt
it to cover the last 7 months: http://peltiertech.com/Excel/Charts/DynamicLast12.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Jane wrote: I need to automatically update a chart every month for a report but I only want to plot the current month and six months back each time. For example Feb-Aug for the Aug report then for the Sept report plot Mar-Sept. Any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HELP - need to returns the current number of past month this year and ... | Excel Worksheet Functions | |||
| Current Month Query | Excel Worksheet Functions | |||
| Automatically enter date and time but only update once. | New Users to Excel | |||
| Automatic Chart Update? | Charts and Charting in Excel | |||
| Can't save chart as object in current sheet | Charts and Charting in Excel | |||
Linear Mode
