Show only workdays in chart axis?

D

Dan

Hi,

I have created a dynamic named-range that I use as the data source for my
scatter plot chart's x-axis. I only type in dates that are workdays in that
range.

When I graph my data the chart is still showing the weekends, just with no
data points in there. It is stretching my graph out and skewing the look.

Is there a way to set the graph to only show weekdays and just skip the
weekends?

Thanks!
-Dan
 
D

Dan

I should add I have tried right-clicking on the chart -> chart options ->
axes -> and trying to select the Category radio button but it is grayed out,
possibly because I am using a named field as the data source?
 
A

Andy Pope

Hi,

You need to change the chart type to Line rather than xy-scatter in order to
swap between Category and Time series axis.

Cheers
Andy
 
D

Dan

Thanks Andy! That did it!
-Dan



Andy Pope said:
Hi,

You need to change the chart type to Line rather than xy-scatter in order to
swap between Category and Time series axis.

Cheers
Andy
Click to expand...
 

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

Create a chart from a table in word thats dynamic 0
Plotting Graph with dynamic table 3
How to getting text labels to show up in scatter chart. 0
Getting the graph style I want 4
Chart with differing x axis 1
Extending The Horiz. Axis Question ? 2
Doughnut Chart linked with the slicer in the pivot table 0
Chart x axis problem 1

Top