Dates and Charts

W

Wayne Burritt

Hi: I have a chart that has dates and data for every work day -- but not
the weekends. The problem is for the weekends, excel leaves blanks. Is
there a way to get the dates to be uniform across the X axis? Thanks, Wayne
 
D

Debra Dalgleish

Select the chart
Choose Chart>Chart Options
Select the Axes tab
Under 'Category (X) Axis, select Category
Click OK
 

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

Gantt chart duration not showing 0
XY Charts Excluding Weekends 1
How to create a bubble chart with more than 2 variables. 0
How to remove weekends from the chart 2
Excel 2010 - Line Chart with Mulitiple Data Sets 1
One extra x axis item that wont go away - can anyone help? 3
Show only workdays in chart axis? 4
simple chart 0

Top