Weekdays only on X axis

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My source data only includes weekdays, but when I plot a line chart, my X
axis puts in weekends, too. How can I skip weekends and only display data
for weekdays?
 
To change the setting from a time-scale:

Select the chart
Choose Chart>Options
Select the Axes tab
For Category (X) axis, choose Category, click OK
 
Thank you so much. It's perfect!

Debra Dalgleish said:
To change the setting from a time-scale:

Select the chart
Choose Chart>Options
Select the Axes tab
For Category (X) axis, choose Category, click OK
Click to expand...
 
Back
Top