Help with X- Axis!!!

[Guest]

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

 

[David Biddulph]

Are you using a line chart? It sounds like you need an XY chart instead.
[XY can include lines, with or without data point symbols.]

 

[Guest]

Thank you David. Yes, that works however, I am going to make it more
complicated.....

I am trying to use the graph option that allows me to plot 2 graphs with a
y-axis on the right and 1 on the left. I have inserted blank rows between my
data points. I then went to tools--> options--> chart and said to
interpolate between the blank cells.

My last challenge is this: If I have 3 points that are plotted (Day 1, Day
4 and Day 10), can I customize my axis axis so that I only see tick
marks/labels for those 3 points where I have data.....rather than seeing
2,4,6,8,10?

Thanks.

Are you using a line chart? It sounds like you need an XY chart instead.
[XY can include lines, with or without data point symbols.]
--
David Biddulph

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

 

[Bernard Liengme]

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

 

[Guest]

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

Thanks again in advance.

Chris

 

[Bernard Liengme]

When you have missing data in the range of holding the x-values, it is best
to fill the blanks with =NA(). This displays as #N/A and is ignore by the
chart engine.
best wishes

 

[Guest]

Great. Thanks very much.

When you have missing data in the range of holding the x-values, it is best
to fill the blanks with =NA(). This displays as #N/A and is ignore by the
chart engine.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email