Remove the weekends from a pivot chart x axis

R

rinkuchat

Joined
Nov 5, 2014
Messages
1
Reaction score
0
Hi,
I have a pivot chart, where the x axis has dates.
I need to remove the weekends from the x axis on the pivot chart.
What should be the excel formula ?
please suggest.

Thanks:)
 

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

Adding custom x axis labels to histogram generated from a pivot table 1
Pivot Chart Dual Category Axis not Preserving Formatting 2
How to put same scale on X and Y axis on graph 2
Pivot Table Chart Drop Down Box 6
proper scaling in chart (with time-scale X-axis) 2
Pivot Chart - Excel 2013 - Rotating Second and Third Lines of text onthe Horizontal Axis 0
Formatting pivot chart axis labels for dates 10
How to remove weekends from the chart 2

Top