| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Remove old month from chart add new/no manual reference change
In article ,
says... jan feb mar apr 10 20 30 40 I want to graph the latest 4 months without having to go in a change refrences in the chart each month. Next month feb mar apr may 20 30 40 50 If I drag the last months across to pick up the formulas for the next month I get 5 months on the graph instead of 4 See Dynamic Charts http://www.tushar-mehta.com/excel/ne...rts/index.html particularly, example 2. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Make a line in a bar chart, and change color of any bars that exceed the line | Excel Discussion (Misc queries) | |||
| Chart - slect month by Combo box | Charts and Charting in Excel | |||
| How do I change the colors of each slice in a pie chart easily? | Charts and Charting in Excel | |||
| change default chart settings for new excel charts automatically | Charts and Charting in Excel | |||
| change chart title with auto filter | Charts and Charting in Excel | |||
Threaded Mode
