Business Days in Chart

T

Terence

I have a chart with days in the x-axis. My source data only has business
days, but they show up on the chart with 0 data. How can I remove those days
from the chart?
 
A

Andy Pope

Hi,

Right click the chart and pick Chart Options.
On the axis tab set the X axis to be Category rather than Automatic or time.

Cheers
Andy
 

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

Filtered view of Visio Chart 0
Gantt chart duration not showing 0
One extra x axis item that wont go away - can anyone help? 3
Employee Schedule not plotting properly - chart type / data series not correct 0
Move Chart with Text 0
Countdown macro - display settings 2
Cannot see and gantt charts or other displays 0
Drop down list control value in vba 2

Top