Thank you Bernanrd....can you please explain what you mean by set x values =
to NA()?

Thanks again in advance.

Chris

"Bernard Liengme" wrote:

To get 'correct' spacing you need an XY chart with 1, 4, 10
If you have Day 1, Day 4 , etc you have categorical data and can make a line
or column chart.
If you want a line/column chart with 'correct' spacing use Day 1, Day 2, Day
3....
and for the x-values use =NA()
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"CMD" wrote in message
...
Hi. I am trying to graph data in Excel. My x-axis is days. I have data
points for Day 1, Day 4 and Day 10. When I graph, it doesn't space the
data
points proportionally. There is the same distantance between 1 & 4 as
there
is between 4 & 10. Its like it gets treated as categorical versus
numerical.
Any guidance would be greatly appreciated.

Also, is there a way that I can insert tick marks on the x-axis only where
I
have data points (only on days 1, 4 and 10 on the example above)?

Thank you.

Chris