Thread: [SOLVED] Weekdays only on X axis

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?
--
TIA, Nancy

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


NNester wrote:
> 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?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Are you sure you have a line chart and not an XY plot?


"NNester" wrote:

> 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?
> --
> TIA, Nancy

Thank you so much. It's perfect!

"Debra Dalgleish" wrote:

> 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
>
>
> NNester wrote:
> > 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?
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>
>