excel data

[chipy]

hi

thanks to all who've helped me on my previous excel and word questions.

this time i'm working with an excel bar graph. on the x-axis i have dates and on the y-axis i have numbers. the dates are not consecutive... they are counted by one day a week. when i plot the bar graph, it shows empty spaces for the dates in between the dates i have listed on the x-axis.

for example, my dates are Oct 31, Nov 7, and Nov 14. i can plot the graph with this data but it also lists the dates in between with no bars. i don't want the dates in between on my graph... how do i get rid of them?

thanks
chipy

 

[WannaFly]

I believe if you format the cell as text it wont do this.