How can the last 12months on the x-axis auto update each month?

F

Faisal78

My chart sould always display the last 12 months and every month I have to
change the axis range so it displays the latests 12 months. I have seen this
being used before so I know it can be done. Can you please help?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

One extra x axis item that wont go away - can anyone help? 3
Auto Scale x-axis 2
Automate chart X-axis/data 1
X-Axis Units Disappear in Stacked Area Chart (Excel 2007) 0
Set position of x axis labels 2
Plotting against Date (collating months) 2
Y axis data point alignment with x axis dates 0
Excel 2007: X-axis labeling 1

Top