1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Is it possible to limit the date range on a pivot graph?

I have a pivot graph that I'm filtering by customer to show sales per month. I have 'show items with no data' selected in field settings for date, because I need to see all the previous months in the graph, whether or not sales were made in that month.

My only issue now is, is that it shows all the months of the year, so it looks like sales have flatlined at the end of the graph, when really I just don't have that data included yet.

Is there any way to force the pivot graph to end at February 2026 rather than December 2026? Or is it a compromise I have to make to have 'show items with no data' selected?

Maybe I could make a new column for mmm yyyy, but then how can I ensure it's in order? (And if possible, I'd also like it to look more "chunked" into years and months, rather than just Jan 26, Feb 26, etc.)

submitted by /u/i-love-dregins
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#generative AI for data analysis
#big data management in spreadsheets
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#natural language processing for spreadsheets
#financial modeling with spreadsheets
#rows.com
#Excel compatibility
#Excel alternatives
#pivot graph
#show items with no data
#date range
#sales per month