Pivot Chart using Dates for Category Axis

  • Thread starter Thread starter Victoria@DIG
  • Start date Start date
V

Victoria@DIG

I have a pivot chart the uses dates for the category axis. I'd like it to
automatically adjust to show today and the previous 6 days. How would I do
this?
 
In the query, add a filter to the date field of ... Date() - 6
 
Thanks! I used the following in my date field and it worked great!
 
You must log in or register to reply here.

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

Remove the weekends from a pivot chart x axis 0
Formatting pivot chart axis labels for dates 10
Pivot Chart with 2 horizontal axis field (categories) 1
Category Axis 1
Pivot Chart Dual Category Axis not Preserving Formatting 2
Multi Axis Pivot Chart 12
Pivot Chart - Excel 2013 - Rotating Second and Third Lines of text onthe Horizontal Axis 0
Pivot Chart - X-axis labels when adding data 0

Back
Top