Creating a graph in excel 2007 ?

Question

I want to create a graph that has data on the vertical axis and dates on the horizontal axis. I only want certain dates on the horizontal axis for example i want 7/05/2008, 7/10/2008, 7/15/2008. How do i get it so those dates show up and only those dates, aka not all the dates between 7/05/2008 and 7/15/2008.

Answer 1

Create the graph and right click on the dates you see on the x-axis.

Then format axis and change the min or max values for the dates you want to see.

Answer 2

On the page with your horizontal axis dates, type in your first & second date.  Select both cells then drag.  Excel will fill the remaining cells.  Or you can use the charts wizard.  Or Mr. Clipit might be able to help you.