Charting only the dates shown

  • Thread starter Thread starter Ivan
  • Start date Start date
I

Ivan

I am using Excel 2007 and have a chart of dates and accompanying data. Excel
is being very nice and adding in all the missing dates for me. I do not want
it to do this. How can I tell Excel to just plot the data that it sees
thankyouverymuch?

Basically I am plotting a burndown chart and am excluding weekends because
no work is done at that time. Excel adds in the weekend dates.
 
Right click the axis, choose Format. Find where there are the three choices
for axis type: Automatic, Text, and Date. Change to Text and Excel will no
longer try to make a complete set of dates.

- Jon
 

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

How to create a bubble chart with more than 2 variables 0
XY Charts Excluding Weekends 1
Show only workdays in chart axis? 4
normal distribution chart 2
Line and Bar on same chart 2
Odd chart type needed 2
Dynamically Scale Gantt Chart Time Scale 2
Date range in x axis 1

Back
Top